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

185 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
cecities1231204(None) 
canities101519262canities
cavities131412612cavities
cerites94823432cerit_es
cities84524852__cities
comities12317792comities
deities82621922de_ities
ferities111416712ferities
lenities8315942lenities
levities11310712levities
neckties1445902neckties
recites93524582recit_es
verities111418042verities
accidies1338043accidies
acerbities1444973acerbities
acetifies1447133acetifies
acidities12810183acidities
acuities10312453acuities
aerifies111313393aerifies
amenities11310433amenities
amities9317383_amities
ascites9312603ascit_es
beasties102514653beasties
beauties10229523beauties
bedirties1275683bedirties
brevities1446423brevities
caciques21165373caciques
caducities1544893caducities
calcifies1638923calcifies
calcites12313003calcit_es
calvities1438943calvities
capacities1647693capacities
catties94023053c_atties
cavitied14126813cavitied
cecity1398153cecit__y
ceilis85413743ce_ili_s
celeries10316313celeries
celerities1289773celerities
cenotes92814543cenot_es
centiles103615813centiles
centimes124012613centimes
centres93817123ce_ntres
cerates95428253cerat_es
ceratins102818733ceratins
cercises12410933cerci_ses
cerises94722253ceri_ses
cerite84724873cerit_e_
certes84623083ce_rt_es
certifies14310323certifies
cetes75731103ce__t_es
ceviches1834843ceviches
chanties132615803chanties
charities14312743charities
chedites1438263chedit_es
chilies124218303c_hilies
chitins122713793c_hitins
chitties13310773chitties
chivies153412853c_hivies
christies1449263christies
cicelies1269753cicelies
circuities1446913circuities
cites74435593__cit_es
citied94014143__citied
citifies13310683citifies
civies114116443__civies
clarities11312483clarities
clerisies1147253clerisies
clitics11279973c_litics
cocottes1238303cocottes
codifies1439643codifies
coesites101313093coesit_es
colitis92617353coliti_s
colitises11311743colitises
conicities14412633conicities
coonties10513803coonties
cooties93725733c_ooties
counties10316283counties
coxitides1945113coxitides
coxitis16238463coxiti_s
critics112811093c_ritics
crucifies1646123crucifies
crudities1247743crudities
cubicities1646823cubicities
curites93919863curit_es
cuties84927363__cuties
cutties93118843c_utties
dacites101114593dacit_es
dacoities1248213dacoities
deciares11510633deciares
decides114217653deci_des
deciles104417723deci_les
decries103319803dec_ries
decuries11312223decuries
deictics1345563deictics
deifies113317453de_ifies
densities10310793densities
deputies1157533deputies
dimities11314003dimities
edacities1247773edacities
edifies113012283_edifies
elites66027123_elit_es
empties11712243_empties
enmities10611353enmities
entities8617413entities
equities17310773equities
evites94916473_evit_es
excites16310633excit_es
fealties1139993fealties
felicities1549743felicities
feracities1548713feracities
ferocities1548243ferocities
fixities1838213fixities
genitives1346663genitives
hearties11315413hearties
heinies102514543he_inies
helicities1549853helicities
incites93218483incit_es
jetties143613123je_tties
laities7320343_laities
laxities1539093laxities
lealties8310793lealties
lecithins1443983lecithins
lectins92515003lec_tins
lefties10312073le_fties
lenites7818443lenit_es
lenitives1247503lenitives
leucites1037333leucit_es
lucites9311863lucit_es
megacities1546673megacities
meinies92516073me_inies
necktie1344363necktie_
niceties10310863niceties
nudities939683nudities
obesities1145843obesities
oddities1046603oddities
opacities1347943opacities
outcities1149513outcities
pacifies15311223pacifies
parities10522973parities
paucities1348503paucities
pectines121914683pectines
pectins112315233pec_tins
pectizes21229793pectizes
pelites93821993pelit_es
petites93820203petit_es
pities83828083__pities
polities102722343polities
purities10316283purities
rarities8316333rarities
raucities1148163raucities
realities9316313realities
realties8514853realties
recipes113314463reci_pes
recitals1039763recitals
recite83625113recit_e_
recited104319103recit_ed
reciter94117263recit_er
reciters102613113reciters
reciting113118073reciting
recits83621353recit__s
recopies12313733recopies
rectifies14310813rectifies
reifies104218283re_ifies
resites74027793resit_es
reties65436193re__ties
retitles83612593retitles
sanities81219773sanities
scarcities1446403scarcities
securities1248553securities
societies1148803societies
specifies1647573specifies
techies12513603tec_hies
tectites1039993tectites
tenacities1248583tenacities
tensities9311333tensities
tenuities949763tenuities
unities72520153_unities
vacuities1447143vacuities
vanities111414493vanities
velites103417303velit_es
velocities1546473velocities
veracities1549503veracities
verifies141313483verifies
verites103822263verit_es
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 Limit1461621856.71621763.3
3Display Results1851850.0802312.5
 (SQL Overall)1786911857.20224811.3
 
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.