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 “dimities” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

212 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
dimities1131400(None) 
amities9317382_amities
comities12317792comities
deities82621922d_eities
digitizes2046922digitizes
dignities1149592dignities
dirties83119382di_rties
ditties83116982di_tties
dominies113513192dominies
enmities10611352enmities
fixities1838212fixities
limites92915452limit_es
nimieties1145222nimieties
abilities11714143abilities
acidities12810183acidities
acuities10312453acuities
agilities10810973agilities
aminities11312913aminities
anilities9516003anilities
aridities10911633aridities
avidities13107613avidities
canities101519263canities
cavities131412613cavities
cecities12312043cecities
cimices13279803cimi_ces
cities84524853__cities
citifies13310683citifies
dacites101114593dacit_es
dacoities1248213dacoities
dailies84219263d_ailies
dainties9312403dainties
dairies84217733d_airies
daisies84217093d_aisies
dakoities1444673dakoities
damnifies1545543damnifies
dauties83315763d_auties
dawties113312703d_awties
debilities13411293debilities
deifies113317453d_eifies
demies94825803dem__ies
demises103719563demi_ses
demits94918073demit__s
demitted12288773demitted
demotes104717673demot_es
demotics1338753demotics
densities10310793densities
deputies1157533deputies
dhooties1237643dhooties
diamides1238823diami_des
diamines11311643diami_nes
diaries83321953di_aries
dickies143416343di_ckies
diclinies1247833diclinies
dictier103411863di_ctier
dictiest113212783di_ctiest
diddlies1137593diddlies
didies84621833d__idies
digamies1238643digamies
digitals1045433digitals
digitize1947023digitize
digitized2145343digitized
digitizer2044393digitizer
digitizers2143143digitizers
digits84114533digit__s
dignifies1446363dignifies
dilates83220663dilat_es
dillies84122163di_llies
dilutes82911973dilut_es
dimerizes2167943dimerizes
dimes85833043dim___es
dimeter10411893dimet_er
dimeters11411093dimeters
dimidiates1444603dimidiates
diminish14127523diminish
diminishes1644973diminishes
diminutives1752583diminutives
dimity12310473dimit__y
dimples122813213dim_ples
dimplier1336673dimplier
dimpliest1436583dimpliest
dimwits1344513dim_wits
dimwitted1642293dimwitted
dinettes9310193dinettes
dinghies1347363dinghies
dingies93618243di_ngies
dinkies123716033di_nkies
dioecies1138933dioecies
dioptres1146113dioptres
diorites9313523diorit_es
dipodies1238413dipodies
dirtied93210853di_rtied
dirtier83312093di_rtier
dirtiest93014203di_rtiest
dismisses1245503dismisses
distils83015803di_stils
disunities1177783disunities
dites66339153d__it_es
ditzes163212423d__itzes
divides123211453divi_des
divines113514723divi_nes
divinise1267143divinise
divinises1367013divinises
divinities1447733divinities
divinizes2266673divinizes
divvies1457663di_vvies
dixits144210313dixit__s
dizzies16279753di_zzies
docilities1349003docilities
doilies84017363d_oilies
domiciles1445423domiciles
domicils1345073domicils
domines102918973domi_nes
dominie103111643dominie_
dominoes11349043dominoes
dualities10310443dualities
dubieties1245283dubieties
dummies123012133dum_mies
dunites8313593dunit_es
duties74921903d__uties
edacities1247773edacities
eighties12710803eighties
empties11712243_empties
entities8617413entities
equities17310773equities
families1339443families
ferities111416713ferities
fifties132111083fi_fties
finites10315923finit_es
fomites123613203fomit_es
furmities1447543furmities
gimmies123010113gim_mies
homilies132710113homilies
hominies133012953hominies
imides94515343_imi_des
imines84918353_imi_nes
imitates10310503_imitates
immies102412443_im_mies
impieties1345963_impieties
implies11312123_implies
iritis63113733_iriti_s
iritises839973_iritises
jimmies18328783jim_mies
kibitzes2342863kibitzes
kilties113014143ki_lties
kitties113213623ki_tties
laities7320343_laities
laxities1539093laxities
lenities8315943lenities
levities11310713levities
limited102310233limit_ed
limiteds11184543limiteds
limiter92710853limit_er
limiters10249333limiters
limiting1138813limiting
limitless1142943limitless
limits82514143limit__s
militias1048633militias
mimetites1346823mimetites
mimicries1544763mimicries
minifies13312903minifies
mites75141803__mit_es
mitier83620673__mitier
mitiest93520053__mitiest
mitis75425993__miti_s
mitises9315543__mitises
mitres83922073__mitres
niceties10310863niceties
nidifies1238233nidifies
nifties102612503ni_fties
nighties121011383nighties
nineties8312913nineties
nudities939683nudities
oddities1046603oddities
parities10522973parities
pieties9419223pi_eties
pigsties1139783pigsties
pinites9319533pinit_es
piosities11311723piosities
pities83828083__pities
polities102722343polities
primitives1745623primitives
privities14312043privities
purities10316283purities
ramifies13310503ramifies
ramilies10311833ramilies
rarities8316333rarities
righties12711573righties
rimosities1246633rimosities
samites93118713samit_es
sanities81219773sanities
similes92915233simi_les
simitars1046483simitars
simonies10311113simonies
sixties14310973si_xties
smites83921923_smit_es
smithies1337913_smithies
somites94219123somit_es
timidities1346553timidities
timothies1444713timothies
titties73617363ti_tties
trinities9313343trinities
unities72520153_unities
unmitres1036863unmitres
utilities9610803utilities
vanities111414493vanities
verities111418043verities
viduities1346113viduities
vilifies1439593vilifies
vinifies1439873vinifies
vivifies1747023vivifies
vomitives1744613vomitives
whities133113253_whities

Search took 8 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 Filter1786911461620.423422437.4
2DLD Change Limit1461622126.78021557.8
3Display Results2122120.0932279.6
 (SQL Overall)1786912127.29624491.6
 
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.