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

132 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
student84834(None) 
students954681students
prudent10310432prudent
stent55634512st__ent
strident9310172strident
stunt55328172stu__nt
ardent73022613_ardent
attent62818323at_tent
audient8312303_audient
cadent94120363_cadent
candent10417363candent
credent10313973credent
crudest104510333crudest
dent57158413___dent
eluent6315483elu_ent
erodent8313823erodent
esculent1047183esculent
etude63612303etude__
etudes73811603etude_s
evident1139993evident
fluent9313933flu_ent
hutment1239173hutment
impudent1346283impudent
indent73021243_indent
louden73711793louden_
loudens8368053loudens
loudest839933loudest
lucent8313823_lucent
mordent10313993mordent
nonstudent1154153nonstudent
nudest74113833_nudest
obtundent12112703obtundent
opulent938833opulent
outwent10311363outwent
patulent1048603patulent
pendent10314723pendent
rident7520193_rident
rodent7519243_rodent
rudest74016313_rudest
sadden83212403sadden_
saddens9309603saddens
saddest92412383saddest
salient7419763salient
sapient9415333sapient
sarment9318763sarment
saturant8410643saturant
scandent1148493scandent
scent75831623s__cent
segment10312563segment
sent46963013s___ent
sequent16410323sequent
serpent92916283serpent
shent85933503s__hent
shunt85226513shu__nt
silent64125843s_ilent
sklent103614353s_klent
snidest8310913snidest
sodden84011513sodden_
soddens9348413soddens
solvent10310833solvent
sorbent92915243sorbent
soudan73210353soudan_
soudans8309353soudans
soundest9510973soundest
sourest7515713sourest
spent75532833s__pent
splent84720193s_plent
sprent84522383s_prent
squint154214793squ_int
stade64825303stade__
stades74626243stade_s
staidest939803staidest
stalest73720173stalest
stamen84115943stamen_
stamens93411483stamens
statant7313123statant
stelene7310253stelene
steno54716863st__eno
stents65019453st__ents
stet45947323st__e_t
stint57037663st__int
stipend10386553stipend
stolen64315063stolen_
stouten7307333stouten_
stoutens8255273stoutens
stoutest837613stoutest
street64125773st_reet
strudel835783strude_l
strudels934123strudels
strunt64918913st_runt
stud56220093stud___
studded10236873studded
studdie9195273studdie
studding1136703studding
studied9268693studied
studier82510053studier
studiers9236623studiers
studies82413863studies
studio7247133stud_io
studios8256643studios
studliest1036573studliest
studly10397693stud_ly
studs64415873stud__s
study94411793stud__y
studying1335553studying
stun45623453stu__n_
stung65417153stu__ng
stunk94616293stu__nk
stunned8358893stunned
stunner7349193stunner
stuns54719493stu__ns
stunts65615253stu__nts
stupe75217753stupe__
stupefy1542903stupefy
stupes84116953stupe_s
stupidest1244143stupidest
sturdiest10207393sturdiest
sturt56028963stu__rt
stylet94018573style_t
styrene10116693styrene
subnet82520933s_ubnet
subrent9315083subrent
sudden83310833sudden_
suddens9308783suddens
suet46754823s_u_e_t
suint55638183s_u_int
surest65026763s_urest
syndet10311963synde_t
talent6323323_talent
tent46159863_t__ent
trident8314193trident
turgent8712393_turgent

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.406440125.6
2DLD Change Limit1340271327.06318975.9
3Display Results1321320.0462869.6
 (SQL Overall)1786911327.51523777.9
 
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.