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 “sparoid” 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.

241 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
sparoid10231154(None) 
sparid94016931spar_id
sparoids11218711sparoids
spiroid10219821spiroid
sporoid102310731sporoid
acaroid103512312acaroid
aroid65428342__aroid
parotid102915512_parotid
sarcoid10310452s_arcoid
sarod65325872s_aro_d
sepaloid1146762sepaloid
sialoid8310962sialoid
spared95427492spar_ed
sparged113512762sparged
sparids103512122spar_ids
sparked143513142sparked
sparred104512862sparred
spheroid1447282spheroid
steroid81314862steroid
acarid95017073acar_id
agatoid948623agatoid
ambroid1238883ambroid
android9311513android
aneroid8314003aneroid
arid57642713__ar_id
aroids75118223__aroids
ascarid103910723ascar_id
asteroid9511193asteroid
avoid95516683__avoid
carotid102014833_carotid
choroid13311803choroid
droid74218543__droid
emeroid101511183emeroid
fibroid1337243fibroid
gadoid9310463_gadoid
ganoid8314443_ganoid
haloid104317763_haloid
haploid1339833haploid
hyaloid1439073hyaloid
hydroid1539713hydroid
labroid1038823labroid
lianoid837533lianoid
negroid9108893negroid
neuroid81110303neuroid
ochroid1357903ochroid
opioid9310083op_ioid
pagod95013683_pago_d
paid75737483_pa__id
pallid93915283_pallid
paranoid11311143_paranoid
parboil1138323_parboil
pard76441323_par__d
pardi85723953_pardi_
pardie96021443_pardie
pared86946763_par_ed
parged104922043_parged
paris75145943_par_is
parked134425143_parked
parled94626293_parled
parodic122311723_parodic
parodied1238333_parodied
parody12410093_parody
parol74826273_paro_l
parole84425253_parole
paroled104217633_paroled
parols84722613_parols
parotic112518043_parotic
parotids112610413_parotids
parotoid11410033_parotoid
parous84024163_parous
parred95024073_parred
parried103615723_parried
parsed96323893_parsed
parted94228683_parted
partied103516553_partied
parvis116114803_parvis
patois84319363_patois
pavid115717003_pa_vid
percoid12312313_percoid
period9314983_period
peroxid17310273_peroxid
placoid1239773placoid
prod76129503_p_ro_d
proud84615483_p_roud
pyoid11513763_p_yoid
said55742113s_a__id
saiyid10167413s_aiyid
salpid9510883s_alpid
sapid84720933s_a_pid
saprobe1137333saprobe
saprobic1445263saprobic
sapwood1366913sapwood
sarcoids1137803s_arcoids
sard55344243s_ar__d
sari45444043s_ar_i_
sarin55239253s_ar_in
saris54544953s_ar_is
sarode75317513s_arode
sarods74918573s_arods
sarong73914873s_arong
saros55238063s_aro_s
sayid95516723s_a_yid
sayyid13185353s_ayyid
scaphoid1646053scaphoid
scaraboid1443753scaraboid
scared95227293scar_ed
scarfed134711183scarfed
scarped124314403scarped
scarred104512633scarred
scarted104816123scarted
schrod1247883schro_d
sciuroid1144403sciuroid
scleroid1147213scleroid
scrod85115073s_cro_d
seafood1146153seafood
seared75232843sear_ed
searobin1045713searobin
sesamoid1144063sesamoid
shamois123210423shamois
shard96125963shar__d
shared105829063shar_ed
sharia93116733shar_ia
sharif122917123shar_if
sharked153613913sharked
sharped134112053sharped
sharpie1238403sharpie
shroud1038773s_hroud
sialid7314943sia_lid
sigmoid1146113sigmoid
siluroid945053siluroid
simioid1047993simioid
sistroid947263sistroid
sleazoid1843203sleazoid
sloid64619713s__loid
smaragd1134393smaragd
smarted105012613smarted
smartie9310173smartie
snared74824553snar_ed
snarfed11378753snarfed
snarled83612363snarled
soared74324293soar_ed
sordid83411163s_ordid
spaced114517253spa_ced
spaded103816753spa_ded
spadix1636113spa_dix
spado83713703spado__
spaed85522273spa__ed
spahi10311143spa_hi_
spahis11310383spa_his
spail74921553spa__il
spait75631603spa__it
spalled103113133spalled
spammed14348523spammed
spanked143111733spanked
spanned104111223spanned
spar65433303spar___
spare75135563spar__e
sparely123410673sparely
sparer84524963spar_er
sparerib1264363sparerib
sparers94519613sparers
spares84834553spar_es
sparest94616433sparest
sparge94216053spar_ge
sparger103613083sparger
sparges104016343sparges
sparging122611133sparging
sparing104823873sparing
spark114920893spar__k
sparker133914363sparker
sparkier14298033sparkier
sparkily1735023sparkily
sparking152812543sparking
sparkish17276973sparkish
sparkle133710213sparkle
sparkled15317733sparkled
sparkly16348133sparkly
sparks124616363spar_ks
sparky154511523spar_ky
sparlike1437673sparlike
sparling112714533sparling
sparrier10329143sparrier
sparring113112223sparring
sparrow1234263sparrow
sparrows1344803sparrows
sparry115111303spar_ry
spars75431543spar__s
sparse84516343spar_se
sparser94311483sparser
sparsity1345463sparsity
spartan948333spartan
spartina1037983spartina
spasmed12296993spasmed
spastic11310383spastic
spathed134013183spathed
spathic1437543spathic
spatted104014143spatted
spavie113611383spa_vie
spavin114210653spa_vin
spawned13316803spawned
spayed124213613spa_yed
speared104314423spear_ed
spermic1338523spermic
sphenoid1446323sphenoid
spheroids1545543spheroids
spired94921863spir_ed
spirit83519923spir_it
spirted103913073spirted
spoil75818653sp__oil
spoored104411293spoored
spored94821793spor_ed
sported104015433sported
sportif1238803sportif
sprain83614863sp_rain
sprayed13398903sprayed
spread9312533sp_read
sprig85617743sp_r_ig
sprit76736403sp_r_it
sprout8419403sp_rout
spurned10339263spurned
spurred103610623spurred
spurted103111973spurted
staid66722083sta__id
stared75429873star_ed
starlit71512913starlit
starred85013453starred
started84217323started
starved114911573starved
steroids9911443steroids
stroud7310383s_troud
styloid1137553styloid
subarid10310653subar_id
sward94221463swar__d
swarded1238153swarded
swarmed1367483swarmed
theroid11313403theroid
thyroid1438253thyroid
toroid7416013_toroid
upbraid1244973upbraid
viroid10411523_viroid
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.420425454.8
2DLD Change Limit1340272416.72019944.5
3Display Results2412410.0763171.1
 (SQL Overall)1786912417.21624763.2
 
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.