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

364 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
strange8541634(None) 
estrange9488891estrange
strang75718311strang_
stranger94715101stranger
stranges94516761stranges
strangle98411501strangle
arrange838682arrange
astringe938222astringe
derange939812derange
estranged11387662estranged
estranger10447842estranger
estranges10359982estranges
grange83716202_grange
orange74016322_orange
outrange92410222outrange
range64728412__range
sprang95713522sprang_
sprangs104610052sprangs
springe103913982springe
stage65330192st_a_ge
stance84316912st_ance
stane55933002st_an_e
stang66424682st_ang_
stanged94113842st_anged
stangs75018162st_angs
storage8310472stora_ge
strafe95215982stra_fe
straggle10359132straggle
strake104017392stra_ke
strand74514822stran_d
stranded102710812stranded
strander97112062strander
strands83711952strands
strangely1345412strangely
strangers104112162strangers
strangest103210842strangest
strangled11268982strangled
strangler10369472strangler
strangles103011552strangles
stravage1245562stravage
string75327562string_
stringed102911872stringed
stringer93812942stringer
strings84617132strings
stringy114111072stringy
strong74914882strong_
stronger9349692stronger
strung75213022strung_
syringe11349472syringe
trance84718762_trance
arranged1036933arranged
arranger936883arranger
arranges939413arranges
astringed1145693astringed
astringes1038333astringes
borage93917013bora_ge
borane84620213boran_e
carnage10311743carnage
change124116753_change
crane75331603_cran_e
cringe93515483_cringe
deranged1137693deranged
deranger1037353deranger
deranges1039973deranges
durance1059113durance
enrage72715073enra_ge
entrance10311333entrance
estrangers11376103estrangers
estrone7413953estron_e
ethane94613243ethan_e
flange103411973_flange
forage104617003fora_ge
fringe104013953_fringe
furane94015493furan_e
garage8314513gara_ge
granger93514213_granger
granges93516523_granges
grunge8359583_grunge
harangue1244103harangue
iterance1049523iterance
mange84930193__mange
melange1038363melange
midrange1244433midrange
mirage92313653mira_ge
orang65119943_orang_
oranges84215333_oranges
orangey11388833_orangey
orangs74116033_orangs
orangy105111233_orangy
ourang73311063ourang_
ourangs8318503ourangs
outrage82616893outra_ge
outrance102212783outrance
outrang83813953outrang_
outranged11239043outranged
outranges102510013outranges
parang93715513parang_
parangs104314373parangs
prance104318573_prance
prang84820323_prang_
pranged114512553_pranged
prangs94816233_prangs
rage55742353__ra_ge
rance75028513__rance
ranee55438103__ranee
rang56939163__rang_
ranged84824313__ranged
ranger73925523__ranger
ranges73826923__ranges
rangy95320383__rangy
sage55044593s__a_ge
sane45954343s__an_e
sang55441233s__ang_
sanga66023793s__anga
sanger74524563s__anger
sangh95517453s__angh
saran53730303saran__
sarans64224433saran_s
sarape84817573sara_pe
sarge65531133s__arge
sarong73914873sarong_
sarongs84511803sarongs
satang75711563satang_
satangs8479713satangs
savage10410173sava_ge
scrag85916173scra_g_
scragged1335823scragged
scraggy14304583scraggy
scrags95713803scra_gs
scraigh1335673scraigh
scrannel1044033scrannel
scrape105917573scra_pe
scrapie115010943scrapie
scrooge1037183scrooge
scrouge1036353scrouge
scrounge1143913scrounge
seance83716693s_eance
serape84818413sera_pe
serene63522353seren_e
serfage1138403serfage
serge64727473ser__ge
serine65432673serin_e
sering74731813sering_
seringa83310743seringa
sewage10310733sewa_ge
shrank13359123shran_k
shrine94920053shrin_e
signage937773signage
silage72715303sila_ge
silane62718053silan_e
singe65731133s__inge
siring75128313siring_
skeane104611373skean_e
slang66324023s_lang_
slanged94112853s_langed
slangs75615343s_langs
slangy105411393s_langy
socage91012123soca_ge
sonance9310313sonance
soring74731883soring_
sorings83817253sorings
spang84919733s_pang_
spangle1038403s_pangle
sparge94216053s_parge
spinage10289653spinage
sponge939663s_ponge
sprag86418693spra_g_
sprags95715823spra_gs
spring94526013spring_
springed123911323springed
springer113311753springer
springes114014033springes
springs104415923springs
springy13359663springy
sprung94610033sprung_
stable83921643st_able
stacte82113913st_acte
stade64825303st_a_de
stag57332003st_a_g_
staged84521563st_a_ged
stager74821343st_a_ger
stages75629493st_a_ges
stagey105915583st_a_gey
stagged104212083st_agged
stagger94212393st_agger
staggie9138463st_aggie
staggy115510393st_aggy
stags66226743st_a_gs
stagy96618893st_a_gy
staig65519643st_aig_
staigs75414813st_aigs
stake95927533st_a_ke
stale55637103st_a_le
stances93715963st_ances
stanch113812373st_anch
stand65923283st_an_d
standee83514513st_andee
stander84316163st_ander
stands75118053st_ands
staned74824643st_aned
stanes64933403st_anes
stanine73417073st_anine
stank95823303st_an_k
stanks104917703st_anks
stanol6310723st_anol
stanza1537073st_anza
staple84415823st_aple
stare54440263st_a_re
staring84527053staring_
starnose8136693starnose
startle72511123startle
starve94613743st_arve
state56237333st_a_te
statue66015323st_atue
stave85324993st_a_ve
stealage946583stealage
steerage946833steera_ge
sting65330243st_ing_
stinger84314683st_inger
stingo74212163st_ingo
stings76220183st_ings
stingy105213203st_ingy
stoae55024263stoa__e
stodge8369043st_odge
stone55431183st_on_e
stooge73811663st_ooge
storable10310733storable
storages9311103stora_ges
storing83921123storing_
stowage1136703stowage
straddle10186223straddle
strafed114413333strafed
strafer103912463strafer
strafes104516003strafes
strafing122111193strafing_
straggled12296853straggled
straggler11377293straggler
straggles11328503straggles
straggly13355563straggly
straight1249183straight
strain64919573stra_in
strained9412253strained
strainer8512223strainer
strains74218153strains
strait64025893stra_it
straiten838613straiten
straiter8311783straiter
straits74916323straits
straked125415343straked
strakes114218073strakes
stranders10389933stranders
strangered1245413strangered
stranglers11396823stranglers
strangury1343203strangury
strap77925263stra__p
strapped1357823strapped
strapper1258093strapper
strappy14205263strappy
straps87721783stra_ps
strass67117223stra_ss
strasses81311443strasses
strata63616283stra_ta
stratagem1263933stratagem
stratal72710603stratal
stratas73013583stratas
strategy1244363strategy
strath93216373stra_th
straths102711723straths
strati63518903stra_ti
stratum9318253stratum
stratus73011733stratus
stravaged1444193stravaged
stravages1345843stravages
straw813321293stra__w
strawed114813613strawed
strawier1137493strawier
strawing122411623strawing_
straws98718673stra_ws
strawy1210312823stra_wy
stray88525573stra__y
strayed114513283strayed
strayer104312503strayer
straying122912693straying_
strays96417933stra_ys
strength1244433strength
strette7310763strette
striae65422273str_iae
striate74218953striate
stride75420963str_ide
strife95318363str_ife
strike105619733str_ike
stringent1049093stringent
stringers104210643stringers
stringier1036713stringier
stripe85822443str_ipe
strive95020963str_ive
strobe84513813str_obe
strode75215973str_ode
stroke105116173str_oke
strongest10338293strongest
strongly1245953strongly
strongmen1244323strongmen
strongyl1243553strongyl
strongyle1343113strongyle
strophe1239143strophe
strove95014793str_ove
struggle10345053struggle
strumae9368093strumae
strunt64918913strun_t
strunted957243strunted
strunts7429543strunts
stung65417153st_ung_
stying105414573stying_
styrene10116693styren_e
surge65027693sur__ge
surname937603surname
swage94919563s_wa_ge
swang95519723s_wang_
swinge105614383s_winge
syringa11366353syringa
syringed13377583syringed
syringes122810213syringes
tang56138673_t_ang_
tanga64923693_t_anga
tanged84622493_t_anged
tangle74019953_t_angle
tango66921173_t_ango
tangs65028343_t_angs
tangy94519933_t_angy
targe65227093_t_arge
tenge65720443_t_enge
thanage11117943_thanage
thane86122533_than_e
tinge64626623_t_inge
trace75829613_tra_ce
trade65026043_tra_de
tragi64717173_tra_gi
trainee72817793_trainee
tranced104414173_tranced
trances93919643_trances
tranche123312223_tranche
trangam1039353_trangam
trank96222423_tran_k
tranks104017763_tranks
tranny94210863_tranny
tranq145416893_tran_q
tranqs155210313_tranqs
trans54933043_tran_s
trave85223033_tra_ve
triage72812893_triage
triangle935533_triangle
trine54734603_trin_e
trone55131863_tron_e
trudge8318733_trudge
twang94511853_twang_
twanged12387273_twanged
twanger11327433_twanger
twangle1145803_twangle
twangs10358093_twangs
twangy13386983_twangy
twinge104210403_twinge
wrang94716113_wrang_
wrangle1137383_wrangle
wrangs104611913_wrangs

Search took 9 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.406440125.6
2DLD Change Limit1340273647.59317651.4
3Display Results3643640.1262888.9
 (SQL Overall)1786913648.12521992.7
 
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.