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

225 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
entities861741(None) 
enmities10611351enmities
entitles8710661entitles
densities10310792densities
endites83717062endit_es
entices91616332enti_ces
entires71517782enti_res
entireties1047272entireties
entitle7610292entitle_
entitled967502entitled
entries71523162ent_ries
equities17310772equities
identities1146952identities
intitles8710002intitles
lenities8315942len_ities
tensities9311332tensities
tenuities949762tenuities
unities72520152un_ities
untidies939812untidies
acuities10312453acuities
amenities11310433amen_ities
amities9317383_amities
analities9715873analities
anilities9516003anilities
annuities947463annuities
antibias10312083antibias
antiques1738883antiques
antitypes1445543antitypes
anxieties1646263anxieties
beatifies1459283beatifies
butties93217953but_ties
canities101519263canities
catties94023053cat_ties
cavities131412613cavities
cecities12312043cecities
centiares1167653centiares
centiles103615813centi_les
centimes124012613centi_mes
centuries11311333centuries
certifies14310323certifies
chitties13310773chitties
cities84524853__cities
citifies13310683citifies
comities12317793comities
cutties93118843cut_ties
deities82621923_deities
densifies1347993densifies
dentalities1249543dentalities
denticles1237753denticles
dentines93418403denti_nes
dentistries1253423dentistries
dentition1049633dentition
dentitions1148853dentitions
destinies10410843destinies
dimities11314003dimities
ditties83116983dit_ties
eateries8324313eateries
edacities1247773edacities
edifies113012283e_difies
effigies1543513effigies
eighties12710803eighties
elites66027123e_lit_es
empties11712243e_mpties
enates64026433en_at_es
enclitics1345163enclitics
endite73817593endit_e_
endited93512913endit_ed
enditing10311073enditing
endives113710693endi_ves
enemies9313693en_emies
energies9310783energies
engines81114463engi_nes
enisles72312603en_isles
enlistees954583enlistees
enormities1246903enormities
enquiries1854383enquiries
enriches1337263enriches
ensiles72714833ensi_les
enskies1138573en_skies
enstatites1044523enstatites
entails7912823ent_ails
entases72816273ent_ases
entasias8269143entasias
entasis73012573entasi_s
ententes8312773ententes
enterics10312853enterics
enteritides1245843enteritides
enteritis9411303enteriti_s
enteritises1147723enteritises
enthuses1138253enthuses
entice81316863enti_ce_
enticed101411193enti_ced
enticer91510423enti_cer
enticers10139093enticers
enticing11311803enticing
entire61617703enti_re_
entitling1037103entitling
entity9312053entit__y
entoils7810733ent_oils
entrails8310163entrails
entrains8312963entrains
entreaties1048113entreaties
entrees71813773ent_rees
entropies11411023entropies
entwines1148753entwines
envies9314053en__vies
equites162212493equit_es
estates74520183estat_es
eutaxies1545793eutaxies
evites94916473e_vit_es
excites16310633excit_es
expiries1747753expiries
fatties103018203fat_ties
fatuities1246913fatuities
ferities111416713ferities
fixities1838213fixities
genitives1346663gen_itives
gentiles93713523genti_les
gentilities1249133gentilities
gentries91315263gent_ries
gentrifies1446893gentrifies
hotties103016963hot_ties
identifies1445803identifies
inanities9312443inanities
incites93218483incit_es
indites83618983indit_es
interties9320333interties
intines7921113inti_nes
intitle7610583intitle_
intitled967343intitled
intitules966773intitules
invitees11377903invitees
invites103915813invit_es
jetties143613123jet_ties
jutties143814003jut_ties
kitties113213623kit_ties
laities7320343_laities
laxities1539093laxities
lenites7818443len_it_es
lenitives1247503len_itives
lentigines1144243lentigines
levities11310713levities
mentalities13410023mentalities
mutinies10311503mutinies
nasties73520493_nasties
neckties1445903neckties
nettier74211813net_tier
nettiest83112433net_tiest
nettles73214083net_tles
nifties102612503_nifties
nites55736343_n_it_es
nitres65519333_n_itres
nittier73512243_nittier
nittiest82712603_nittiest
nixies135313873_n_ixies
nonentities1158263nonentities
notifies11310423notifies
nudities939683nudities
oddities1046603oddities
otitides937293_otitides
otitis63612343_otiti_s
otitises839163_otitises
outcities1149513outcities
outpities1148623outpities
parities10522973parities
patties93425143pat_ties
penalities121313473penalities
penalties11139513penalties
penlites10312273penlit_es
petites93820203petit_es
pettitoes1144183pettitoes
pities83828083__pities
polities102722343polities
potties93723543pot_ties
purities10316283purities
putties94420023put_ties
quantities1946293quantities
rarities8316333rarities
ratifies11313513ratifies
ratites74920683ratit_es
realities9316313realities
rectifies14310813rectifies
renotifies1356893renotifies
retitles83612593retitles
sanctities1247553sanctities
sanities81219773sanities
satieties939383satieties
senilities10312993senilities
sensitise947293sensitise
sensitises1047643sensitises
sensitives1346133sensitives
sensitizes1946963sensitizes
sentries81318053sent_ries
stimies9316563_stimies
stithies1139233_stithies
tantivies1247103tantivies
tatties74120343tat_ties
tectites1039993tectit_es
tektites1236613tektit_es
tenacities1248583tenacities
tentatives1345483tentatives
testifies12139263testifies
tidies74721833__tidies
tithes94720213__tithes
titis56023813__titi_s
titles63719923__titles
titres64718933__titres
titties73617363__titties
tutties73216473tut_ties
unifies102714713un_ifies
unites65024853un_it_es
unitizes1739133un_itizes
unmitres1036863unmitres
unpitied1138793unpitied
untidied1038903untidied
untidier946783untidier
untidiest1046033untidiest
unties64326923un__ties
untitled978763untitled
vanities111414493vanities
vastities1248933vastities
venalities131510723venalities
venosities1347473venosities
verities111418043verities
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.406440125.6
2DLD Change Limit1461622257.25020160.3
3Display Results2252250.0932419.4
 (SQL Overall)1786912257.74923059.9
 
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.