Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “spiroid” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

158 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
spiroid1021982(None) 
sparoid102311541sparoid
sporoid102310731sporoid
opioid9310082opi_oid
sciuroid1144402sciuroid
sparid94016932spar_id
sparoids11218712sparoids
spheroid1447282spheroid
spired94921862spir_ed
spirit83519922spir_it
spirted103913072spirted
steroid81314862steroid
viroid10411522_viroid
acaroid103512313acaroid
ambroid1238883ambroid
android9311513android
aneroid8314003aneroid
aroid65428343__aroid
aspired1068173aspir_ed
aspirin937823aspir_in
asteroid9511193asteroid
choroid13311803choroid
cirsoid1038123_cirsoid
cricoid1239243cricoid
crinoid1039943crinoid
diploid11310293diploid
droid74218543__droid
emeroid101511183emeroid
epizoic2045193epizoic
ericoid1049893ericoid
fibroid1337243fibroid
hydroid1539713hydroid
irid55927173__ir_id
labroid1038823labroid
lipoid9411043_lipoid
negroid9108893negroid
neuroid81110303neuroid
ochroid1357903ochroid
ophiuroid1591933ophiuroid
opioids1036523opi_oids
parotid102915513_parotid
percoid12312313_percoid
period9314983_period
peroxid17310273_peroxid
pirog83913673_piro_g
pirogi9299013_pirogi
prod76129503_p_ro_d
proud84615483_p_roud
pyoid11513763_p_yoid
quinoid1737353quinoid
rhizoid2044583rhizoid
saiyid10167413sai_yid
sarcoid10310453sarcoid
sarod65325873s_aro_d
schizoid2344353schizoid
schrod1247883schro_d
scincoid1344753scincoid
scirrhoid1552723scirrhoid
sciurid1044923sciurid
scleroid1147213scleroid
scrod85115073s_cro_d
sepaloid1146763sepaloid
shirked153710463shirked
shirred113710503shirred
shroud1038773s_hroud
sialid7314943s_ialid
sialoid8310963sialoid
sigmoid1146113sigmoid
siloed74615303s_iloed
siluroid945053siluroid
simioid1047993simioid
sired66134283s_ir_ed
sirloin747593s_irloin
sistroid947263sistroid
skirled12348183skirled
skirred12347083skirred
skirted12388613skirted
sloid64619713s__loid
smirked14307233smirked
sordid83411163s_ordid
spared95427493spar_ed
sparged113512763sparged
sparids103512123spar_ids
sparked143513143sparked
sparred104512863sparred
speired103811103speir_ed
spermic1338523spermic
sphenoid1446323sphenoid
spheroids1545543spheroids
sphingid1543743sphingid
spiced115218313spi_ced
spied85427713spi__ed
spieled104811883spieled
spiered104412463spiered
spiffed16257103spiffed
spiffied17234823spiffied
spigot9312603spigo_t
spigots1037793spigots
spiked134915553spi_ked
spiled94621993spi_led
spilled103613623spilled
spined95423943spi_ned
spinoff1544933spinoff
spinor839943spino_r
spinors939423spinors
spinose937943spinose
spinous9310443spinous
spinout9311583spinout
spiraea9407983spiraea
spiral83715343spir_al
spiraled1137733spiraled
spirals93212513spirals
spirant9814293spirant
spire75828693spir__e
spirea84015633spir_ea
spireas94412513spireas
spirem104214163spir_em
spireme11478363spireme
spirems11499563spirems
spires84628113spir_es
spirier93214073spirier
spiring103918183spiring
spirited1148973spirited
spirits94112623spirits
spirt75032953spir__t
spirting112913633spirting
spirts85317133spir_ts
spirula9257703spirula
spiry105017353spir__y
spited94820443spi_ted
spitted103912703spitted
spoil75818653sp__oil
spoored104411293spoored
spored94821793spor_ed
sported104015433sported
sportif1238803sportif
sprain83614863sp_rain
spread9312533sp_read
sprig85617743sp_r_ig
sprit76736403sp_r_it
sprout8419403sp_rout
spurned10339263spurned
spurred103610623spurred
spurted103111973spurted
steroids9911443steroids
stirred8359703stirred
stroud7310383s_troud
styloid1137553styloid
swirled11308223swirled
syphiloid1853683syphiloid
theroid11313403theroid
thyroid1438253thyroid
toroid7416013_toroid
upbraid1244973upbraid
virid94116043_vir_id
viroids1137923_viroids
xiphoid2045923xiphoid
zebroid1936463zebroid

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.390458182.1
2DLD Change Limit1340271586.59320328.7
3Display Results1581580.0463434.8
 (SQL Overall)1786911587.02925422.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.