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 “surd” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

252 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
surd5643381(None) 
burd75534261burd
curd77634981curd
nurd56224341nurd
sard55344241sard
sord56237201sord
sudd64719771sudd
sued56537931sued
sura45740291sura
surds65624661surds
sure45447411sure
surf76039311surf
turd56027621turd
urd46427041_urd
absurd935902absurd
auld54125362auld
aura45836252aura
bard75648862bard
bird76128322bird
bud67041272bu_d
bund75530662bund
bur55744692bur_
bura66139532bura
burb85334672burb
burds84626062burds
burg74930362burg
burl64937182burl
burn65636422burn
burp85028882burp
burr65631232burr
burs65847422burs
bury95633592bury
card710245872card
cord76740922cord
crud75219612crud
cud67937452cu_d
cued76329562cued
cur56841982cur_
curb86732222curb
curds85725612curds
curdy115916522curdy
cure66149122cure
cured85932132cured
curf97538782curf
curl66035052curl
curn66731882curn
curr65429652curr
curs65645542curs
curt67051712curt
duad66521412duad
dud56737592du_d
dura55232112dura
dure56341812dure
dured75025402dured
durn56127622durn
duro56228022duro
durr55624352durr
euro45325272euro
fard85639062fard
ford86835492ford
fud76335152fu_d
fund85624982fund
fur66637322fur_
furl77030882furl
furs76735042furs
fury107727972fury
gird65424992gird
gourd71011902gourd
guard74415542guard
guid66022822guid
guru54623912guru
hard85443502hard
herd84933062herd
hued86925852hued
hurds95219072hurds
hurl76029932hurl
hurt77142572hurt
jura116024892jura
jury146719592jury
kuru85521802kuru
lard56742002lard
lord55032082lord
lure45142462lure
lured65427492lured
lurid64618972lurid
lurk86624162lurk
mud67336862mu_d
mura65633302mura
mure65941332mure
mured85726702mured
murid84520582murid
murk105527252murk
murr65225132murr
nard56634452nard
nerd56624942nerd
nurds65518522nurds
nurl45327242nurl
oud47439072ou_d
our36042892our_
ours47237562ours
pard76441322pard
pud65836652pu_d
pur56840552pur_
purda82914692purda
pure65543332pure
puri65931442puri
purl65631422purl
purr64925812purr
purs65641042purs
quad144618702quad
quid144922352quid
quod145413622quod
rudd65917472rudd
rued55729792rued
sad47459202s_ad
said55742112said
sand55338472sand
sards64736182sards
sari45444042sari
sark84938972sark
sarod65325872sarod
saury84317222saury
scad75725772scad
scrod85115072scrod
scry96017762scry
scud76221282scud
scurf104719322scurf
seed55549482seed
send55237292send
ser36752402ser_
sera46141392sera
sere46153472sere
sered65737292sered
serf76340112serf
sers45746652sers
shad86230912shad
shard96125962shard
shed86536152shed
sherd96321152sherd
shod86225062shod
shred98125612shred
shri76021702shri
sild55030582sild
sir35746672sir_
sire46150412sire
sired66134282sired
sirs44338332sirs
skid95720922skid
sled55334372sled
slid55828982slid
slued64220512slued
slur45525152slur_
slurb74116322slurb
slurp74014982slurp
slurs54123372slurs
sned56026052sned
sod46053702s_od
sold54837412sold
sora45746912sora
sorb68333042sorb
sords64527802sords
sore47059532sore
sored66141782sored
sori46039842sori
sorn46641062sorn
sort46264812sort
sound64420022sound
sour45935892sour_
soured74921862soured
sours55230502sours
sped76031492sped
spry96819122spry
spud75818492spud
spued84918472spued
spur65321192spur_
spurn74815452spurn
spurs74621522spurs
spurt77227982spurt
squad155110792squad
squid154211902squid
sri35634002s_ri
stud56220092stud
sturdy1037042sturdy
sturt56028962sturt
sub55445552su_b
suba64926602suba
subs66037122subs
such96424812such
suck106131732suck
sucre75019102sucre
sudds75513592sudds
suds56135292suds
sue35651462su_e
suede64419752suede
suer45334032suer
suers55128482suers
sues46247652sues
suet46754822suet
sugh86423442sugh
suit45649872suit
suk75632972su_k
suks85927122suks
sulk85326652sulk
sulu45128422sulu
sum56346012su_m
sumo67326312sumo
sump86331532sump
sums65837582sums
sun37149032su_n
sung55832172sung
sunk85031812sunk
sunn45423592sunn
suns45841902suns
sup57041942su_p
supe65932762supe
supra73614252supra
sups64834432sups
suq126228992su_q
suqs134319652suqs
surah86823252surah
sural55931262sural
suras55336332suras
surer54833102surer
surfed103814462surfed
surfs85022542surfs
surfy115319472surfy
surge65027692surge
surged84118882surged
surgy95118522surgy
surly85124432surly
surra55521342surra
suss45229302suss
sutra54217932sutra
sward94221462sward
sword95214122sword
turds65021692turds
turf75334052turf
turk86125862turk
turn46330382turn
urb55731102_urb
urds55922422_urds
urn35731462_urn
urp56426392_urp
used55722822used
usurp7106902usurp
usury887622usury
ward86542252ward
word89832002word
wud76227152wu_d
yard85633252yard
yird87018982yird
yurt76435042yurt

Search took 2 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 Filter178691298720.280638182.1
2DLD Change Limit298722520.86034734.9
3Display Results2522520.0634000.0
 (SQL Overall)1786912521.203148537.8
 
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.