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

208 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
surds6562466(None) 
burds84626061burds
curds85725611curds
hurds95219071hurds
nurds65518521nurds
sards64736181sards
sords64527801sords
sudds75513591sudds
suds56135291su_ds
suras55336331suras
surd56433811surd_
surfs85022541surfs
turds65021691turds
urds55922431_urds
absurds1035002absurds
auras55932562auras
aures55137092aures
auris55331532auris
bards87139642bards
birds85421332birds
buds75235172bu_ds
bunds85523542bunds
buras74736302buras
burbs95423492burbs
burd75534262burd_
burgs84924092burgs
burls74228852burls
burns74926782burns
burps94220172burps
burrs74925652burrs
burs65847422bur_s
cards85137932cards
cords86030622cords
cruds85815852cruds
cuds76730472cu_ds
curbs94821652curbs
curd77634982curd_
curdy115916522curdy
cures75645432cures
curfs105122142curfs
curls74927102curls
curns74924282curns
currs75624392currs
curs65645542cur_s
duads76515342duads
duds65530142du_ds
duras65727732duras
dures65635922dures
durns64819872durns
duros65422692duros
durrs65519992durrs
euros54920242euros
fards96629842fards
fords95328182fords
fuds86528562fu_ds
funds94119252funds
furls85322052furls
furs76735042fur_s
girds74816992girds
gourds8108252gourds
guards84611572guards
guids75516152guids
gurus64318192gurus
hards96435652hards
herds96424682herds
hurls86522712hurls
hurts86922822hurts
kurus98015632kurus
lards65331862lards
lords64923502lords
lures56138532lures
lurks95218742lurks
muds75530652mu_ds
muras75329582muras
mures75937222mures
murids93212192murids
murks114821732murks
murrs75521302murrs
nards65928462nards
nerds65719252nerds
nurd56224342nurd_
nurls55519682nurls
ouds56430102ou_ds
ours47237562our_s
pards85634332pards
puds75630512pu_ds
purda82914692purda
purdas92612262purdas
puris75332022puris
purls74723352purls
purrs75320432purrs
purs65641042pur_s
quads154515842quads
quids154917462quids
quods154610222quods
rudds74811702rudds
saids65328852saids
sands65228582sands
sard55344242sard_
saris54544952saris
sarks96632462sarks
sarods74918572sarods
saros55238062saros
scads85419962scads
scrods94111612scrods
scuds85116242scuds
scurfs113210812scurfs
seeds64330062seeds
sends65528242sends
seres55448892seres
serfs84922012serfs
sers45746652ser_s
shads95124482shads
shards104319172shards
sheds96122702sheds
sherds105614722sherds
shreds105613052shreds
shris84221452shris
silds65520522silds
sires55945372sires
sirs44338332sir_s
skids104615332skids
sleds64418852sleds
slurbs8439742slurbs
slurps84410002slurps
slurs54123372slur_s
sneds65715352sneds
sods54940212s_ods
soras55041012soras
sorbs75022102sorbs
sord56237202sord_
sores55454282sores
sorns55028422sorns
sorts54536662sorts
sorus54527582sorus
sounds74616182sounds
sours55230502sour_s
spuds85113672spuds
spurns84811382spurns
spurs74621522spur_s
spurts84814972spurts
squads164410292squads
squids16409802squids
sris45434152s_ris
studs64415872studs
sturdy1037042sturdy
sturts63915142sturts
subas74724072subas
subs66037122su_bs
sucks114523072sucks
sucres84218892sucres
sudd64719772su_dd
sudsy95010682su_dsy
sued56537932sued_
suede64419752suede
suedes73918112suedes
suers55128482suers
sues46247652su_es
suets55126102suets
sughs95313322sughs
suits55028052suits
suks85927122su_ks
sulks94818462sulks
sulus54821882sulus
sumos75720092sumos
sumps95023432sumps
sums65837582su_ms
sunns55017352sunns
suns45841902su_ns
supes75628302supes
sups64834432su_ps
suqs134319652su_qs
sura45740292sur_a
surah86823252surah
surahs94515542surahs
sural55931262sural
sure45447412sur_e
surer54833102surer
surest65026762surest
surf76039312sur_f
surfy115319472surfy
surge65027692surge
surges73924592surges
surgy95118522surgy
surly85124432surly
surra55521342surra
surras65919532surras
suss45229302su_ss
sutras64818592sutras
swards105415132swards
swords104510802swords
tsuris62710202tsuris
turd56027622turd_
turfs84620442turfs
turks95320822turks
turns55623242turns
turps74918732turps
urbs65922062_urbs
urd46427052_urd_
urns46323902_urns
urps66920482_urps
urus46426142_urus
usurps8105072usurps
wards97734402wards
words95425072words
yards95324612yards
yirds96612512yirds
yurts87216532yurts

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 Filter178691538000.313570897.8
2DLD Change Limit538002081.56334421.0
3Display Results2082080.0464521.7
 (SQL Overall)1786912081.92292971.4
 
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.