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

199 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
hurl7602993(None) 
burl64937181burl
churl105913881churl
curl66035051curl
furl77030881furl
harl75740001harl
herl75834551herl
hull75428781hull
hurls86522711hurls
hurly115819291hurly
hurt77142571hurt
nurl45327241nurl
purl65631421purl
thurl84912681thurl
ahull84010312ahull
aura45836252aura
aural54428962aural
birl65830472birl
buhl95518222buhl
bull65634872bull
bur55744692bur_
bura66139532bura
burb85334672burb
burd75534262burd
burg74930362burg
burls74228852burls
burly104922832burly
burn65636432burn
burp85028882burp
burr65631232burr
burs65847422burs
bury95633592bury
byrl95716012byrl
carl65144782carl
churls115411072churls
churn105113102churn
churr104512852churr
cull65929642cull
cur56841982cur_
curb86732222curb
curd77634982curd
cure66149122cure
curf97538782curf
curls74927102curls
curly105321232curly
curn66731892curn
curr65429652curr
curs65645542curs
curt67051712curt
dirl57430022dirl
dual55928172dual
duel56729702duel
dull56430442dull
dura55232112dura
dural64923892dural
dure56341812dure
durn56127632durn
duro56228022duro
durr55624352durr
earl45838142earl
euro45325272euro
farl76338552farl
fuel76824732fuel
full75229152full
fur66637322fur_
furls85322052furls
furs76735042furs
fury107727972fury
girl56226552girl
gul45832792gu_l
gull54828452gull
guru54623912guru
hail74839062hail
hall75741162hall
hard85443502hard
hare76255732hare
hark115237392hark
harls85634502harls
harm95637792harm
harp96134292harp
hart76865772hart
haul75530452haul
heal75645692heal
heel75034222heel
heil76328932heil
hell75637892hell
her66547812her_
herb94730962herb
herd84933062herd
here76447102here
herls85226432herls
herm95636152herm
hern76134892hern
hero74635782hero
hers75844872hers
hill76439492hill
hire75538962hire
hora76136562hora
horal86328682horal
horn76735612horn
hour75827312hour_
houri85915252houri
hourly12369622hourly
hours85422392hours
howl107625692howl
hub86437482hu_b
hubs96027142hubs
huck135927632huck
hue66642302hu_e
hued86925852hued
hues75235232hues
huff135623842huff
hug76037362hu_g
huge86321652huge
hugs86129752hugs
huh96432012hu_h
huic94818052huic
hula74923752hula
hulk115321612hulk
hullo84417452hullo
hulls84923562hulls
hum85542932hu_m
hump116228722hump
hums96831422hums
hun65844712hu_n
hung86126352hung
hunh106323732hunh
hunk116029542hunk
huns76136932huns
hunt76445492hunt
hup86437812hu_p
hurdle103712792hurdle
hurds95219072hurds
hurled104617452hurled
hurler94717222hurler
hurley125012522hurley
hurry114917182hurry
hurst85527192hurst
hurtle93512942hurtle
hurts86922822hurts
hush105224112hush
husk116021952husk
hut66457292hu_t
huts76737442huts
jarl115828132jarl
jura116024892jura
jural125120482jural
jurel124516332jurel
jury146719592jury
knurl9398912knurl
kuru85521802kuru
lull44225762lull
lure45142462lure
lurk86624162lurk
marl66341622marl
merl65830972merl
mull65128802mull
mura65633302mura
mural75225112mural
mure65941332mure
murk105527252murk
murr65225132murr
null45125312null
nurd56224342nurd
nurls55519682nurls
our36042892our_
ours47237562ours
pul56138062pu_l
pull64731662pull
pur56840552pur_
pure65543332pure
puri65931442puri
purls74723352purls
purr64925812purr
purs65641042purs
rural55821172rural
shorl84720252shorl
shul75823152shu_l
sura45740292sura
sural55931262sural
surd56433812surd
sure45447412sure
surf76039312surf
surly85124432surly
thirl85416822thirl
thurls9418712thurls
tirl45029922tirl
turd56027622turd
turf75334052turf
turk86125862turk
turn46330392turn
urb55731112_urb
urd46427052_urd
urn35731472_urn
urp56426402_urp
virl76224472virl
whirl114913822whirl
whorl114612452whorl
yurt76435042yurt

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 Filter178691298720.296603685.8
2DLD Change Limit298721991.81316476.6
3Display Results1991990.0932139.8
 (SQL Overall)1786911992.20281149.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.