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

196 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
strudel83578(None) 
strudels934121strudels
streel64214022str_eel
streusel843932streusel
stride75420962stride_
strider84315722strider
strides84520392strides
strode75215972strode_
aludel747863_aludel
astride8311973astride_
bordel94514573bor_del
crude86018573_crude_
crudely1336273_crudely
cruder95612383_cruder
crudes96218623_crudes
cruel74815903_cru_el
detrude936083detrude_
detruded1134883detruded
detrudes1036203detrudes
estrual7367933estru_al
estruses838483estruses
etude63612303et_ude_
etudes73811603et_udes
extrude1545013extrude_
extruded1743843extruded
extruder1643993extruder
extrudes1645243extrudes
fardel104712593far_del
gruel66014743_gru_el
intrude837403intrude_
intruded1035993intruded
intruder945213intruder
intrudes937493intrudes
obtrude1044243obtrude_
obtruded1243363obtruded
obtruder1143093obtruder
obtrudes1144073obtrudes
prude84615973_prude_
prudes94215443_prudes
rubel75416833__rubel
rude55632783__rude_
rudely10389973__rudely
ruder65320543__ruder
sarode75317513sarode_
sarodes84216143sarodes
saurel6511993s_aurel
scruple1137193scruple
seidel7311083s_eidel
sequel1556713sequ_el
serumal938783serumal
shrivel13479403shrivel
shrouded1333603shrouded
siruped1036013siruped
sorel56231443sor__el
sorrel6413553sor_rel
spruce103910873spruce_
spruced12307533spruced
sprucely1543123sprucely
sprucer11317683sprucer
spruces113810503spruces
sprue74717633spru_e_
sprues84515763spru_es
staddle9288093staddle
stade64825303st_ade_
stades74626243st_ades
staider83912613staider
stammel11607533stammel
standee83514513standee
stander84316163stander
staumrel1042083staumrel
steaded92811673steaded
steel55721993st__eel
stipel84412123st_ipel
stounded10276213stounded
stoure64814943stoure_
stoures74614163stoures
stouten7307333stouten
stouter74012053stouter
straddle10186223straddle
strafe95215983strafe_
strafed114413333strafed
strafer103912463strafer
strafes104516003strafes
strake104017393strake_
straked125415343straked
strakes114218073strakes
stranded102710813stranded
strander97112063strander
stratal72710603stratal
strawed114813613strawed
strayed114513283strayed
strayer104312503strayer
streek104111413str_eek
streels73811343str_eels
street64125773str_eet
strep77120853str__ep
streusels942933streusels
strew89220663str__ew
strewed115811343strewed
strewer104310413strewer
striae65422273striae_
stridden1044273stridden
strident9310173strident
striders94412123striders
stridor8467393stridor
strife95318363strife_
strifes104716583strifes
strigil837263strigil
strike105619733strike_
striker113714173striker
strikes114719093strikes
stripe85822443stripe_
striped105214363striped
striper94514793striper
stripes95320573stripes
strive95020963strive_
strived114713663strived
striven103910753striven
striver104315203striver
strives104119373strives
strobe84513813strobe_
strobes93813263strobes
strobil936963strobil
stroke105116173stroke_
stroked124613623stroked
stroker114113523stroker
strokes114316323strokes
stroll6311603str_oll
stromal93010593stromal
stroud7310383stroud__
strouds837803stroud_s
strove95014793strove_
strowed115312143strowed
stroyed114110863stroyed
stroyer103510783stroyer
struck12489263stru_ck
strucken1444323strucken
struggle10345053struggle
strum75619453stru__m
struma84313273stru_ma
strumae9368093strumae
strumas9419833strumas
strummed1344473strummed
strummer1234783strummer
strumpet1256033strumpet
strums84716453stru_ms
strung75213023stru_ng
strunt64918913stru_nt
strunted957243strunted
strunts7429543strunts
strut56030733stru__t
struts65616803stru_ts
strutted946343strutted
strutter846503strutter
stud56220093st_ud__
studded10236873studded
student848343st_udent
studied9268693st_udied
studier82510053st_udier
studies82413863st_udies
studio7247133st_udio
studly10397693st_udly
studs64415873st_ud_s
study94411793st_ud_y
stull54916273st_u_ll
stupe75217753st_upe_
stupes84116953st_upes
sturdied10215963sturdied
sturdier9216963sturdier
sturdies92110273sturdies
sturdily1245083sturdily
sturdy1037043sturd_y
syruped1334543syruped
trade65026043_trade_
traded85717683_traded
trader75218763_trader
trades75724503_trades
tramel84113713_tramel
travel94112983_travel
trode65322853_trode_
trowel94211463_trowel
truce75118693_truce_
truced95312053_truced
truces84916333_truces
trudge8318733_trudge
trudged10298043_trudged
trudgen9357053_trudgen
trudger9338733_trudger
trudges9339993_trudges
true46725853_tru_e_
trued65117693_tru_ed
truer54916643_tru_er
trues54925323_tru_es
trull54012673_tru_ll
trundle8307873_trundle
trunnel745403_trunnel

Search took 7 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.436409841.7
2DLD Change Limit1340271966.17321711.8
3Display Results1961960.0603266.7
 (SQL Overall)1786911966.66926794.3
 
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.