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

190 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
surf7603931(None) 
curf97538781curf
scurf104719321scurf
serf76340111serf
sura45740291sura
surd56433811surd
sure45447411sure
surfs85022541surfs
surfy115319471surfy
turf75334051turf
arf67453372_arf
aura45836252aura
barf95844412barf
buff125229862buff
bumf116126512bumf
bur55744692bur_
bura66139532bura
burb85334672burb
burd75534262burd
burg74930362burg
burl64937182burl
burn65636432burn
burp85028882burp
burr65631232burr
burs65847422burs
bury95633592bury
corf95941482corf
cuff125327992cuff
cuif96529142cuif
cur56841982cur_
curb86732222curb
curd77634982curd
cure66149122cure
curfs105122142curfs
curl66035052curl
curn66731892curn
curr65429652curr
curs65645542curs
curt67051712curt
duff114326642duff
dura55232112dura
dure56341812dure
durn56127632durn
duro56228022duro
durr55624352durr
euro45325272euro
fur66637322fur_
furl77030882furl
furs76735042furs
fury107727972fury
guff114624932guff
gulf84929422gulf
guru54623912guru
huff135623842huff
hurl76029932hurl
hurt77142572hurt
jura116024892jura
jury146719592jury
kerf115827462kerf
kuru85521802kuru
luff104426702luff
lure45142462lure
lurk86624162lurk
muff124723862muff
mura65633302mura
mure65941332mure
murk105527252murk
murr65225132murr
nurd56224342nurd
nurl45327242nurl
our36042892our_
ours47237562ours
puff125525432puff
pur56840552pur_
pure65543332pure
puri65931442puri
purl65631422purl
purr64925812purr
purs65641042purs
ruff105127652ruff
sard55344242sard
sari45444042sari
sark84938972sark
saury84317222saury
scarf105427142scarf
scry96017762scry
scuff133914892scuff
scurfs113210812scurfs
scurfy14338762scurfy
seif75638732seif
self75138292self
ser36752402ser_
sera46141392sera
sere46153472sere
serfs84922012serfs
serif84132132serif
sers45746652sers
shri76021702shri
sir35746672sir_
sire46150412sire
sirs44338332sirs
sluff114016812sluff
slur45525152slur_
slurb74116322slurb
slurp74014982slurp
slurs54123372slurs
snarf86525422snarf
snuff113514042snuff
sora45746912sora
sorb68333042sorb
sord56237202sord
sore47059532sore
sori46039842sori
sorn46641062sorn
sort46264812sort
sour45935892sour_
sours55230502sours
spry96819122spry
spur65321192spur_
spurn74815452spurn
spurs74621522spurs
spurt77227982spurt
sri35634002s_ri
stuff113817052stuff
sturt56028962sturt
sub55445552su_b
suba64926602suba
subs66037122subs
such96424812such
suck106131732suck
sucre75019102sucre
sudd64719772sudd
suds56135292suds
sue35651462su_e
sued56537932sued
suer45334032suer
suers55128482suers
sues46247652sues
suet46754822suet
sugh86423442sugh
suit45649872suit
suk75632972su_k
suks85927122suks
sulfa8313922sulfa
sulfo8313362sulfo
sulk85326652sulk
sulu45128422sulu
sum56346012su_m
sumo67326312sumo
sump86331532sump
sums65837582sums
sun37149032su_n
sung55832172sung
sunk85031812sunk
sunn45423592sunn
suns45841902suns
sup57041942su_p
supe65932762supe
supra73614252supra
sups64834432sups
suq126228992su_q
suqs134319652suqs
surah86823252surah
sural55931262sural
suras55336332suras
surds65624662surds
surer54833102surer
surfed103814462surfed
surfer93515882surfer
surge65027692surge
surgy95118522surgy
surly85124432surly
surra55521342surra
suss45229302suss
sutra54217932sutra
swarf115324652swarf
tuff104528522tuff
turd56027622turd
turfs84620442turfs
turfy114315402turfy
turk86125862turk
turn46330392turn
urb55731112_urb
urd46427052_urd
urn35731472_urn
urp56426402_urp
usurp7106902usurp
usury887622usury
yurt76435042yurt
zarf166929122zarf

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.263679433.5
2DLD Change Limit298721900.90632971.3
3Display Results1901900.0464130.4
 (SQL Overall)1786911901.215147070.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.