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

263 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
doits6622367(None) 
dits56450521d_its
doats65224881doats
doit56347851doit_
dolts65626311dolts
dots55647661do_ts
droits74314311droits
duits65021881duits
toits55327471toits
adits66523712adits
admits9411412admits
adopts998082adopts
aits46355532_aits
baits76630582baits
bits66148162_bits
boats75635152boats
boils75427192boils
boite74426322boite
boites84322702boites
bolts76232112bolts
boots75837972boots
borts76735452borts
bots66453952bo_ts
botts75224862botts
bouts75131312bouts
brits76433082brits
chits105424572chits
coats75635002coats
coifs105718702coifs
coils75030082coils
coins75834552coins
coirs75221052coirs
coitus8511892coitus
colts76633292colts
coots75636842coots
costs77231142costs
cots68054842co_ts
crits75527572crits
dacoits1079072dacoits
dais57040702dai_s
dakoits1245292dakoits
darts67635732darts
dauts67822242dauts
davits104012362davits
dawts97216122dawts
debits94214502debits
debts86418372debts
deets65330242deets
deils65722862deils
deist64633592deist
deists74916432deists
deity94316772deity
delts65731792delts
demits94918072demits
dents65031802dents
dhotis1038972dhotis
dibs76233682d_ibs
dies55653522d_ies
diets66026642diets
difs86027322d_ifs
digits84114532digits
digs66036052d_igs
dims75435022d_ims
dins56652042d_ins
dints67431312dints
diols65521012diols
dips75536912d_ips
dirts66824462dirts
dis46459892d_i_s
diss56434482d_iss
dit47071332d_it_
dita56032522d_ita
ditas65923672d_itas
dite55547552d_ite
dites66339152d_ites
ditsy95612562d_itsy
ditz146929512d_itz
dixits144210312dixits
djins1368452djins
doat56947672doat_
dobies94422092dobies
docks126022312docks
docs75631152do_cs
dodos75819392dodos
doers65225712doers
does56554472do_es
doest65829522doest
doeth9411982doeth
doffs125614332doffs
doges75630162doges
dogies85022252dogies
dogs66440152do_gs
doily95321032doily
doing74923582doing
doings84913182doings
doited85016632doited
dojos135111792dojos
doles67843752doles
dolls66126922dolls
dols56943052do_ls
dolt56649422dolt_
domes85735562domes
doms76239572do_ms
donas65926472donas
dongs76525812dongs
dons56048702do_ns
donuts7410582donuts
dooms85321342dooms
doors65022132doors
dopas85019062dopas
dopes84935042dopes
dories75232362dories
dorks105724442dorks
dorms85723842dorms
dorps85419222dorps
dorrs65520592dorrs
dors56747602do_rs
dorty96220812dorty
dos48062312do__s
doses65938502doses
doss56235042do_ss
dost57248352dost_
dot47573182do_t_
dote55442882do_te
dotes65836692dotes
doth86225712do_th
dotty94516102dotty
doty86128222do_ty
doubts968732doubts
doums85417642doums
doves94728152doves
downs94918572downs
dows85941052do_ws
doxies143917852doxies
dozes155226302dozes
drats66628372drats
dribs85115062dribs
dries64733672dries
drifts10499892drifts
drips85417232drips
droids84712582droids
droit65127122droit_
ducts85319892ducts
duets65323882duets
duit56241582duit_
dunts65828412dunts
dusts65923562dusts
edits65819032edits
emits75421472emits
exits125515912exits
fits76043462_fits
flits85625222flits
foils85025812foils
foins85523382foins
foist85730972foist
foists95413982foists
fonts86124752fonts
foots85528282foots
forts86034452forts
frits86129102frits
gaits65726012gaits
gits55744592_gits
goats65527302goats
gouts64826172gouts
grits65529582grits
hits75545132_hits
hoist86433212hoist
hoists95516022hoists
holts85627912holts
hoots84830252hoots
hosts85526702hosts
hots78349332ho_ts
idiots768642idiots
its35538832__its
joins125818412joins
joints133811452joints
joist125125652joist
joists134711032joists
jolts125018882jolts
jots116336142jo_ts
kits86441762_kits
knits93914742knits
kois85129402koi_s
lits46252492_lits
lofts85518362lofts
loids66220702loids
loins56728422loins
loots55431422loots
lots47652092lo_ts
louts56330272louts
moats75827642moats
moils76125752moils
moist76033582moist
molts76032092molts
moots75831662moots
morts75533562morts
mosts76028542mosts
mots66853162mo_ts
motts76527002motts
nits45741642_nits
noils55024332noils
noirs55615462noirs
nowts86915862nowts
oats46554212_oats
obits74617552obits
odist6421912odist
odists749852odists
oils46337972_oils
omits75018262omits
oots46446442_oots
opts68124742_opts
orts46538332_orts
outs45746962_outs
pits66348742_pits
poets76024442poets
points85618532points
pois66539042poi_s
ports75934592ports
posits85718712posits
posts75228782posts
pots66452362po_ts
pouts75530322pouts
quits144122352quits
quoits15379682quoits
riots54922012riots
roils54826792roils
roots55933672roots
rotis56327062rotis
rots46454092ro_ts
routs57133412routs
shits84731172shits
sits45050202_sits
skits94721862skits
slits56128852slits
snits54124832snits
softs85019232softs
soils55327982soils
soots55536212soots
sorts54536662sorts
sots45552452so_ts
spits74429552spits
suits55028052suits
tits46145042_tits
tofts84919242tofts
toils54527492toils
toit46353062toit_
toots55331872toots
torts56138122torts
tots46654122to_ts
touts54830392touts
twits86015792twits
units54923432units
voids95414672voids
volts85421292volts
vomits112610922vomits
waits88333522waits
whits115923822whits
wits76044872_wits
wonts87621542wonts
worts88631182worts
wots76342892wo_ts
writs86624382writs
zits136030292_zits

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.0931921408.6
2DLD Change Limit538002631.43637465.2
3Display Results2632630.0803287.5
 (SQL Overall)1786912631.609111057.2
 
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.