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

246 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
hurt7714257(None) 
curt67051711curt
hart76865771hart
hunt76445491hunt
hurl76029931hurl
hurst85527191hurst
hurts86922821hurts
hut66457291hu_t
yurt76435041yurt
airt45757782airt
art38679142_art
aunt46553652aunt
aura45836252aura
bhut95425712bhu_t
blurt77625622blurt
bort65960962bort
brut66537962brut
bunt65850852bunt
bur55744692bur_
bura66139532bura
burb85334672burb
burd75534262burd
buret77444012buret
burg74930362burg
burl64937182burl
burn65636432burn
burnt75230332burnt
burp85028882burp
burr65631232burr
burs65847422burs
burst75332242burst
bury95633592bury
bust65947782bust
but55963022bu_t
butt65143742butt
cart66570342cart
chart105038282chart
chert105232102chert
churl105913882churl
churn105113102churn
churr104512852churr
court75532772court
cult66541152cult
cunt66243672cunt
cur56841982cur_
curb86732222curb
curd77634982curd
cure66149122cure
curet75447642curet
curf97538782curf
curl66035052curl
curn66731892curn
curr65429652curr
curs65645542curs
curst74931022curst
cut57957662cu_t
dart55857872dart
dirt55550382dirt
duct75735462duct
duet56446262duet
duit56241582duit
dunt55746872dunt
dura55232112dura
dure56341812dure
durn56127632durn
duro56228022duro
durr55624352durr
durst66125172durst
dust57142532dust
euro45325272euro
fart76860562fart
fort76456442fort
fur66637322fur_
furl77030882furl
furs76735042furs
fury107727972fury
girt56646422girt
guru54623912guru
gust55240702gust
gut46753852gu_t
haet75659502haet
haft105941842haft
halt76056302halt
hant75461592hant
hard85443502hard
hare76255732hare
hark115237392hark
harl75740002harl
harm95637792harm
harp96134292harp
harts88441592harts
hast76259482hast
hat67289962h_at
haunt85229132haunt
haut75949732haut
heart85440742heart
heat77061422heat
heft106736292heft
hent76656382hent
her66547812her_
herb94730962herb
herd84933062herd
here76447102here
herl75834552herl
herm95636152herm
hern76134892hern
hero74635782hero
hers75844872hers
hertz174919042hertz
hest75950772hest
het67674312h_et
hilt75850712hilt
hint77455742hint
hire75538962hire
hist76551542hist
hit66569192h_it
holt77852582holt
hoot75752102hoot
hora76136562hora
horn76735612horn
horst85833512horst
host77852832host
hot67776062h_ot
hour75827312hour_
houri85915252houri
hours85422392hours
hub86437482hu_b
hubs96027142hubs
huck135927632huck
hue66642302hu_e
hued86925852hued
hues75235232hues
huff135623842huff
hug76037362hu_g
huge86321652huge
hugs86129752hugs
huh96432012hu_h
huic94818052huic
hula74923752hula
hulk115321612hulk
hull75428782hull
hum85542932hu_m
hump116228722hump
hums96831422hums
hun65844712hu_n
hung86126352hung
hunh106323732hunh
hunk116029542hunk
huns76136932huns
hunts86826172hunts
hup86437812hu_p
hurds95219072hurds
hurls86522712hurls
hurly115819292hurly
hurry114917182hurry
hursts97213092hursts
hurter93915852hurter
hurtle93512942hurtle
hush105224112hush
husk116021952husk
huts76737442huts
jura116024892jura
jurat124829322jurat
jury146719592jury
just115433342just
jut105944012ju_t
kart86750802kart
kurta95113912kurta
kuru85521802kuru
lunt46148842lunt
lure45142462lure
lurk86624162lurk
lust47442602lust
mart66865982mart
mort66758832mort
mura65633302mura
mure65941332mure
murk105527252murk
murr65225132murr
must65145442must
mut58357182mu_t
mutt65739402mutt
nurd56224342nurd
nurl45327242nurl
nut36651962nu_t
ort39465232_ort
our36042892our_
ours47237562ours
oust46747442oust
out38072152ou_t
part65967462part
pert66759322pert
phut96925972phu_t
port66059632port
punt65747202punt
pur56840552pur_
pure65543332pure
puri65931442puri
purl65631422purl
purr64925812purr
purs65641042purs
purty105019402purty
put55759072pu_t
putt66937842putt
quart144027852quart
quirt144624232quirt
quit136136512quit
runt46647992runt
rust45544912rust
rut35560522ru_t
shirt84533902shirt
short85040532short
shunt85226512shunt
shut76137592shu_t
sort46264812sort
spurt77227982spurt
sturt56028962sturt
suet46754822suet
suit45649872suit
sura45740292sura
surd56433812surd
sure45447412sure
surf76039312surf
tart47566182tart
thurl84912682thurl
tort46967462tort
tuft76929512tuft
turd56027622turd
turf75334052turf
turk86125862turk
turn46330392turn
tut36758092tu_t
unhurt9311252unhurt
urb55731112_urb
urd46427052_urd
urn35731472_urn
urp56426402_urp
ut28647032_u_t
vert77249372vert
wart77866082wart
wert79749822wert
whort114623692whort
wort76654752wort
wurst85122992wurst
yurta86014252yurta
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 Filter178691298720.310576422.6
2DLD Change Limit298722460.87634100.5
3Display Results2462460.0633904.8
 (SQL Overall)1786912461.249143067.3
 
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.