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

380 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
sterile731660(None) 
puerile9310092puerile
sedile73517232s_edile
senile63420212s_enile
serine65432672s_erine
servile10310642s_ervile
stabile9312062stabile
startle72511122startle
stearine8311902stearine
steelie7310212steelie
steeple937322steeple
stele55026842ste__le
stere55328542ster__e
steric8317062steri_c
sterilely1244602sterilely
sterilise948992sterilise
sterilize1848292sterilize
sterlet71318472ster_let
sternite8310542sternite
sternly1037852sternly
sterol6613322sterol_
sterols7313442sterols
stile54931572st__ile
striae65422272st_riae
stride75420962st_ride
strife95318362st_rife
strike105619732st_rike
stripe85822442st_ripe
strive95020962st_rive
unsterile946502unsterile
uterine7315192uterine
aedile73716653_aedile
aerie54634603_aeri_e
aerily93017013_aerily
afebrile1342683afebrile
arteriole945893arteriole
asteria7316173asteri_a
asterias8317003asterias
asterisk1248673asterisk
asterism10413253asterism
astride8311973ast_ride
attrite7311833attrite
berime105317333_berime
cerise84822043_cerise
cerite84724873_cerite
coterie9417393coteri_e
decile94619213_decile
defile105216663_defile
deride84420033_deride
derive103817043_derive
edile64819493__edile
eerie55228533_eeri_e
eerily92913563_eerily
eserine7415903eserine
esterase849473esterase
esterify1445623esterify
eterne6311723eter_ne
eternise8119663eternise
eternize17118363eternize
etherize2049463etherize
etoile6312263et_oile
exile126117653__exile
faerie93514683faeri_e
febrile1237153febrile
feriae95618603_feriae
ferine96422583_ferine
ferlie92814053_ferlie
fertile10311733_fertile
ferule93413203_ferule
fierily1339023fierily
flexile1735073flexile
interfile12411043interfile
itemise997453itemise
itemize18106153itemize
iterate71119103iterate
laetrile845193laetrile
laterite8716333laterite
laterize17613293laterize
leerily1037633leerily
materiel10311253materiel
merle75824373_mer_le
niterie7313743niteri_e
nitrile73011373nitrile
overidle1248823overidle
overlie102615013overlie
peerie83617893peeri_e
penile82219603_penile
peril75425953_peril_
periled10316303_periled
perils84121853_perils
petrale9312623petrale
prefile123413183prefile
pterin81014153pteri_n
pterins9812993pterins
pteryla1243303pteryla
pterylae1343013pterylae
refile95122373_refile
rerise64325633_rerise
resile64627673_resile
retile65929673_retile
revile94921613_revile
rile45650533___rile
safrole1037253safrole
satirise8310683satirise
satirize1749693satirize
scarily12311703scarily
sclerite10410713sclerite
scoriae9310893scoriae
scribe104613533s_cribe
scrive115414943s_crive
scurrile1055063scurrile
sectile9311973sectile
seeable91113943seeable
seedily1178583seedily
seine55732873s_e_ine
seise54727853s_e_ise
seize143819503s_e_ize
selle54428313s_e_lle
semple103212753s_emple
seniles72618023s_eniles
serail64222673s_erail_
serails73318363s_erails
seral56336383s_eral_
serape84818413s_erape
sere46153473s_er__e
serene63522353s_erene
serge64727463s_er_ge
serial64625853s_erial
serials73919743s_erials
seriate73722473s_eriate
series64540973s_eries
serif84132133s_eri_f
serifed11811463s_erifed
serifs94017053s_erifs
serin55434443s_eri_n
serines74229543s_erines
sering74731813s_ering
serins64029673s_erins
serve85425963s_er_ve
service1239083s_ervice
sessile739523sessile
setline7313923setline
settle63915663s_ettle
sexily1638853s_exily
sextile1438573sextile
sferics1236133sferics
sheila969843she_ila
sherif122915233sheri_f
sheriff16287693sheriff
sherifs13299683sherifs
shrike134513243s_hrike
shrill94712303s_hrill
shrine94920053s_hrine
shrive125216953s_hrive
siderite9411363siderite
sienite7312713sienite
simile83115633s_imile
smile74823923s__mile
soberize1998883soberize
sorrily1039823sorrily
sparkle133710203sparkle
specie10412223speci_e
speckle15297553speckle
speil75618643spe_il_
speiled104412123spe_iled
speils84116223spe_ils
speise84614253spe_ise
spermine12311433spermine
spherule1343843spherule
spile75230083s__pile
sporule937273sporule
sprite84421773s_prite
spurtle937453spurtle
stabiles10311403stabiles
stable83921643st_able
staddle9288093staddle
stagily1139053stagily
stale55637103st__ale
stanine73417073stanine
staple84415823st_aple
stare54440263star__e
staring84527053staring
starkly14277033starkly
starlet71620123star_let
starlike1238813starlike
starlit71512913starlit
startled9208553startled
startler8248783startler
startles82111963startles
starve94613743star_ve
statice92614033statice
stative102612933stative
steadily1236213steadily
steal56125473ste_al_
stealer72913973ste_aler
steals64020063ste_als
steamily1335803steamily
stearate839713stearate
stearic939423steari_c
stearin7312003steari_n
stearines9311283stearines
stearins8312143stearins
steatite8310583steatite
steel55721993ste_el_
steeled83513213ste_eled
steelier839183steelier
steelies8312553steelies
steels64117983ste_els
steely93612573ste_ely
steepled1135893steepled
steeples1038013steeples
steeply1236293steeply
steerable1146913steerable
steerage946833steerage
steering93916793steering
steeve93710903ste_eve
stein54620533ste_i_n
steins64818343ste_ins
stela54019043ste__la
stelae63716483ste_lae
stelene7310253stelene
steles63725663ste__les
stelic8313083steli_c
stella63612973ste_lla
stellite839533stellite
stemlike1436723stemlike
stencil946893stencil_
stenciled1243963stenciled
stenciler1143783stenciler
stencils1046403stencils
steplike1436733steplike
steppe10319873ste_ppe
stepwise1344163stepwise
stereo65317913ster_eo
stereoed937883stereoed
stereos74314973stereos
steres63929533ster_es
sterical10311243sterical
sterigma1144113sterigma
sterilant947283sterilant
sterilised1145433sterilised
sterilises1048243sterilises
sterility1247763sterility
sterilized2046743sterilized
sterilizer1945503sterilizer
sterilizes1947633sterilizes
sterlets8169273ster_lets
sterling93615553sterling
stern55319123ster__n
sterna63712763ster_na
sternal73411903sternal
sterner7411913sterner
sternites9310073sternites
sterns64616753ster_ns
sternum947733sternum
steroid81314853steroid
steroids9911433steroids
stertor7310083stertor
stewable1337133stewable
stewing113412493stewing
stibine938653stibine
stickle132410973stickle
stifle93611903st_ifle
stiles64328763st__iles
still54922073st__ill
stilt54831983st__ilt
stime76521793st__ime
stipe76523373st__ipe
stipple1146623stipple
stipule936723stipule
stogie7311313stogi_e
stole54928813st__ole
stonily1049433stonily
stoolie739713stoolie
stopple1156583stopple
storable10310733storable
storage8310473storage
store56333813stor__e
storied8515163storied
stories7324273stories
storing83921123storing
stormily1345243stormily
stourie7469343stouri_e
strafe95215973st_rafe
strake104017393st_rake
streel64214023streel_
streeled9267863streeled
streels73811343streels
strette7310763strette
stria55723203st_ri_a
striate74218953st_riate
strick124813203st_rick
strickle1467793st_rickle
strict84821043st_rict
strider84315723st_rider
strides84520393st_rides
strifes104716583st_rifes
striker113714173st_riker
strikes114719093st_rikes
string75327563st_ring
strip77524333st_ri_p
striped105214363st_riped
striper94514783st_riper
stripes95320573st_ripes
strips85719653st_rips
stript85222193st_ript
stripy115812743st_ripy
strived114713663st_rived
striven103910753st_riven
striver104315203st_river
strives104119373st_rives
strobe84513813st_robe
strobile1047033strobile
strode75215973st_rode
stroke105116173st_roke
stroll6311603st_roll
strove95014793st_rove
stubble1136843stubble
stumble1147553stumble
sturdily1245073sturdily
style85519363st__yle
stylise10208953stylise
stylite10219613stylite
stylize19177453stylize
stymie1137623stymi_e
styrene10116693styrene
suberise10813933suberise
suberize19812143suberize
subfile122010503subfile
subrule939643subrule
subtile91912613subtile
sunrise7310813sunrise
superlie10312123superlie
swerve1256293swer_ve
syenite1039773syenite
tearily10311153_tearily
teazle15329553_teazle
tele45040873_te__le
temple102811333_temple
teniae64517353_teniae
tensile72612733_tensile
terce75721843_ter_ce
tercel83612993_tercel
terete6319333_terete
tergite8311003_tergite
termite9313893_termite
termly1138433_termly
terne56426153_ter_ne
terrae62915203_terrae
terrible1046643_terrible
terrine72517573_terrine
terse55026823_ter_se
textile1437223_textile
thrice114311573_thrice
thrill94910593_thrill
thrive125313223_thrive
tile45451443_t__ile
toile54626493_t_oile
tortile7313193_tortile
treble8311663_treble
tribe74420273_t_ribe
trice75127493_t_rice
trifle94012883_t_rifle
trike95320163_t_rike
trill55122933_t_rill
trine54734603_t_rine
tripe75425383_t_ripe
triple84215923_t_riple
trite54730033_t_rite
turtle63213573_turtle
uteri51012983uteri__
utile54718933ut__ile
utricle937913ut_ricle
verbile1249863_verbile
verily122616053_verily
verite94323443_verite
virile9313433_virile
wasterie111211583wasteri_e
waterily1438783waterily
yperite1249893yperite

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.186960704.3
2DLD Change Limit1340273807.23318529.9
3Display Results3803800.1263015.9
 (SQL Overall)1786913807.54523683.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.