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

168 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
surfs8502254(None) 
curfs105122141curfs
scurfs113210811scurfs
serfs84922011serfs
suras55336321suras
surds65624661surds
surf76039311surf_
surfy115319471surfy
turfs84620441turfs
arfs76029962_arfs
auras55932552auras
aures55137092aures
auris55331532auris
barfs104826002barfs
buffs135519512buffs
bumfs125414052bumfs
buras74736292buras
burbs95423492burbs
burds84626062burds
burgs84924092burgs
burls74228852burls
burns74926772burns
burps94220172burps
burrs74925652burrs
burs65847422bur_s
cuffs135017492cuffs
cuifs104814692cuifs
curbs94821652curbs
curds85725612curds
cures75645432cures
curf97538782curf_
curls74927102curls
curns74924272curns
currs75624392currs
curs65645542cur_s
duffs125216622duffs
duras65727722duras
dures65635922dures
durns64819862durns
duros65422692duros
durrs65519992durrs
euros54920242euros
furls85322052furls
furs76735042fur_s
guffs124414822guffs
gulfs94915302gulfs
gurus64318192gurus
huffs144514742huffs
hurds95219072hurds
hurls86522712hurls
hurts86922822hurts
kerfs125413572kerfs
kurus98015632kurus
luffs114516282luffs
lures56138532lures
lurks95218742lurks
muffs134114212muffs
muras75329562muras
mures75937212mures
murks114821722murks
murrs75521292murrs
nurds65518522nurds
nurls55519682nurls
ours47237562our_s
puffs134114932puffs
puris75332022puris
purls74723352purls
purrs75320432purrs
purs65641042pur_s
ruffs114516742ruffs
sards64736182sards
saris54544952saris
sarks96632462sarks
saros55238062saros
scarfs114714682scarfs
scuffs14419052scuffs
scurf104719322scurf_
scurfy14338762scurfy
seifs85019332seifs
selfs85220242selfs
seres55448892seres
serf76340112serf_
serifs94017052serifs
sers45746652ser_s
shris84221442shris
sires55945372sires
sirs44338332sir_s
sluffs12349582sluffs
slurbs8439742slurbs
slurps84410002slurps
slurs54123372slur_s
snarfs95113422snarfs
snuffs12358522snuffs
soras55041012soras
sorbs75022102sorbs
sords64527802sords
sores55454282sores
sorns55028422sorns
sorts54536662sorts
sorus54527582sorus
sours55230502sour_s
spurns84811382spurns
spurs74621522spur_s
spurts84814972spurts
sris45434152s_ris
stuffs123810222stuffs
sturts63915142sturts
subas74724072subas
subs66037122su_bs
sucks114523072sucks
sucres84218892sucres
sudds75513592sudds
suds56135292su_ds
suers55128482suers
sues46247652su_es
suets55126102suets
sughs95313322sughs
suits55028052suits
suks85927122su_ks
sulfa8313922sulfa
sulfas9311562sulfas
sulfo8313362sulfo
sulks94818462sulks
sulus54821882sulus
sumos75720092sumos
sumps95023432sumps
sums65837582su_ms
sunns55017352sunns
suns45841902su_ns
supes75628302supes
sups64834432su_ps
suqs134319652su_qs
sura45740292sur_a
surah86823252surah
surahs94515542surahs
sural55931262sural
surd56433812sur_d
sure45447412sur_e
surer54833092surer
surest65026762surest
surfed103814462surfed
surfer93515882surfer
surfers103614132surfers
surge65027692surge
surges73924592surges
surgy95118522surgy
surly85124422surly
surra55521342surra
surras65919532surras
suss45229302su_ss
sutras64818592sutras
swarfs125612062swarfs
tsuris62710202tsuris
tuffs115118262tuffs
turds65021692turds
turf75334052turf_
turfy114315402turfy
turks95320822turks
turns55623232turns
turps74918732turps
urbs65922052_urbs
urds55922422_urds
urns46323892_urns
urps66920472_urps
urus46426132_urus
usurps8105072usurps
yurts87216532yurts
zarfs174713622zarfs

Search took 3 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.0931921408.6
2DLD Change Limit538001682.15624953.6
3Display Results1681680.0463652.2
 (SQL Overall)1786911682.29577861.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.