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

179 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
hefts11621815(None) 
efts76519481_efts
hafts116219461hafts
heats85838401heats
heft106736291heft_
hefty146112131hefty
hents87330741hents
hests85829931hests
hets75547201he_ts
lefts86517811lefts
thefts12387921thefts
wefts116715491wefts
beats76042242beats
beets76131442beets
befits114711502befits
belts75931162belts
bents76033692bents
bests75932612bests
bets67051442be_ts
celts75325782celts
cents74730332cents
cheats114519542cheats
chefs136214662chef_s
cherts115617232cherts
chests114916262chests
clefts114610162clefts
debts86418372debts
deets65330242deets
defats105114552defats
defis96717502defis
deft85540222deft_
delfts10439672delfts
delts65731792delts
dents65031802dents
eats47054872_eats
effs105114032_effs
efs66829602_ef_s
eft66038822_eft_
feats86432752feats
felts85324542felts
fests85828042fests
fets75345942fe_ts
gelts65924612gelts
gents65729612gents
gests66028812gests
gets55442482ge_ts
gifts96214962gifts
haets86525122haets
haft105941842haft_
halts85230102halts
hants86335402hants
harts88441592harts
hats76858252h_ats
heads95127112heads
heals85733462heals
heaps105223222heaps
hears86737372hears
hearts96218942hearts
heat77061422heat_
heath115724282heath
heaths126316382heaths
hebes105521672hebes
hecks145220652hecks
heeds95420422heeds
heels85625532heels
hefted134911422hefted
hefter124313922hefter
hefters134312002hefters
hehs106723962he_hs
heils85222192heils
heirs85618562heirs
heist87030912heist
heists96814632heists
hells85032042hells
helms105619462helms
helos84928062helos
helots95217702helots
helps105219342helps
hemes105031082hemes
hemps126917332hemps
hems95534942he_ms
hens75642572he_ns
hent76656382hent_
herbs105520502herbs
herds96424682herds
heres86245902heres
herls85226432herls
herms105626432herms
herns84825582herns
heros84930862heros
hers75844872he_rs
hertz174919042hertz
hes66654202he__s
hest75950772hest_
het67674312he_t_
heth107028022he_th
heths116317782heths
hews105631572he_ws
hexes155123042hexes
hilts86924412hilts
hints87330622hints
hists86328372hists
hits75545132h_its
holts85627912holts
hoots84830252hoots
hosts85526702hosts
hots78349332h_ots
huffs144514742huffs
hunts86826172hunts
hurts86922822hurts
huts76737442h_uts
jefes155613672jefes
jests125922452jests
jets115834102je_ts
keets95123482keets
kefs115922742kef_s
kelts95222632kelts
khets124913432khe_ts
leets54927122leets
left76340482left_
lefty115613562lefty
lets47147942le_ts
lifts85719062lifts
lofts85518362lofts
meats75034052meats
meets74224612meets
melts74930102melts
neats55931902neats
nerts55924982nerts
nests55728002nests
nets45941532ne_ts
netts55320722netts
newts86015282newts
peats76140192peats
pelts76128812pelts
pests75933272pests
pets66248332pe_ts
rafts87820632rafts
refits94017652refits
refs75732242ref_s
reft75141272reft_
rents55935182rents
rests54935872rests
rets45352562re_ts
rifts85718642rifts
seats54844342seats
sects75622892sects
septs75420602septs
sets45549502se_ts
setts55124322setts
sexts125118382sexts
shafts125411442shafts
sheets93918502sheets
shifts124412942shifts
sifts84918922sifts
softs85019232softs
teats55636812teats
teffs115111732teffs
tents56434212tents
tests56530192tests
tets45847462te_ts
texts125515042texts
theft114118132theft_
tofts84919242tofts
tufts85713272tufts
vents86125932vents
verts85724732verts
vests85325982vests
vets76835092ve_ts
wafts116920552wafts
weets85427722weets
weft105435012weft_
welts85225192welts
wests85727002wests
wets75940292we_ts
wheats125013222wheats
whets115019612whe_ts
yetts86715132yetts
zests145419742zests

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.343520965.0
2DLD Change Limit538001791.56334421.0
3Display Results1791790.0463891.3
 (SQL Overall)1786911791.95291542.5
 
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.