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

174 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
debts8641837(None) 
debits94214501debits
debs76530241deb_s
debt77139021debt_
debuts93911751debuts
deets65330241deets
delts65731791delts
dents65031801dents
abets75621672abets
adepts9117102adepts
beats76042242beats
beets76131442beets
belts75931162belts
bents76033692bents
bests75932612bests
bets67051442be_ts
celts75325782celts
cents74730332cents
dabs77139402dab_s
darts67635732darts
dauts67822242dauts
dawts97216122dawts
deads75726912deads
deals65435342deals
deans66131392deans
dears65736882dears
death94822522death
deaths105914442deaths
deb66342692deb__
debag94212302debag
debags104211062debags
debar85517862debar
debars94218042debars
debase94014472debase
debate94419192debate
debates103718532debates
debit85727852debit
debris93311492debris
debtor938332debtor
debtors1038532debtors
debug94210062debug
debugs10467822debugs
debut86024142debut
debye1138902debye
debyes1238102debyes
decks124822192decks
decos85522122decos
deeds75423762deeds
deems85421772deems
deeps84921772deeps
deers64930522deers
dees56356632de_es
deet57356582deet_
defats105114552defats
defis96717502defis
deft85540222deft_
degas75119162degas
deils65722862deils
deist64633592deist
deists74916432deists
deity94316772deity
dekes105224452dekes
deles65139252deles
delfs94918672delfs
delfts10439672delfts
delis64928542delis
dells66630942dells
dels56745472de_ls
delt57855272delt_
delta66117772delta
deltas74414822deltas
demes86032692demes
demits94918072demits
demos86022992demos
denes65639722denes
dens55945072de_ns
dent57158412dent_
depots94716342depots
depth114311852depth
depths12428572depths
derats74625062derats
derms85022892derms
desks105913072desks
devas96218882devas
devs86424032de_vs
dews86230602de_ws
dexes135224512dexes
deys85027472de_ys
dibs76233692dib_s
diets66026642diets
dints67431312dints
dirts66824462dirts
dits56450532d_its
doats65224882doats
doits66223672doits
dolts65626312dolts
dots55647662d_ots
doubts968732doubts
drats66628372drats
dubs78432192dub_s
ducts85319892ducts
duets65323882duets
duits65021882duits
dunts65828412dunts
dusts65923562dusts
eats47054872_eats
ebbs82411992_ebbs
edits65819032edits
efts76519482_efts
feats86432752feats
felts85324542felts
fests85828042fests
fets75345942fe_ts
gelts65924612gelts
gents65729612gents
gests66028812gests
gets55442482ge_ts
heats85838402heats
hebes105521672hebes
hefts116218152hefts
hents87330742hents
hests85829932hests
hets75547202he_ts
jests125922452jests
jets115834102je_ts
keets95123482keets
kelts95222632kelts
leets54927122leets
lefts86517812lefts
lets47147942le_ts
meats75034052meats
meets74224612meets
melts74930102melts
neats55931902neats
nebs66124982neb_s
nerts55924982nerts
nests55728002nests
nets45941532ne_ts
netts55320722netts
newts86015282newts
peats76140192peats
pelts76128812pelts
pests75933272pests
pets66248332pe_ts
rebs65733562reb_s
rebus75721112rebus
rebuts84015192rebuts
rents55935182rents
rests54935872rests
rets45352562re_ts
seats54844342seats
sects75622892sects
septs75420602septs
sets45549502se_ts
setts55124322setts
sexts125118382sexts
teats55636812teats
tents56434212tents
tests56530192tests
tets45847462te_ts
texts125515042texts
vents86125932vents
verts85724732verts
vests85325982vests
vets76835092ve_ts
webs96622122web_s
weets85427722weets
wefts116715492wefts
welts85225192welts
wests85727002wests
wets75940292we_ts
yetts86715132yetts
zebus164610052zebus
zests145419742zests

Search took 9 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 Filter178691538001.170152727.4
2DLD Change Limit538001746.7837931.6
3Display Results1741740.1401242.9
 (SQL Overall)1786911748.09322079.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.