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

101 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
amenities1131043(None) 
aminities11312911aminities
adenitis947432adeniti_s
adenitises1145722adenitises
amanitins1147132amanitins
amentias1039412amen_tias
amities9317382am__ities
amnesties1166872amnesties
arenites8917102arenit_es
lenities8315942_lenities
abilities11714143abilities
acerbities1444973acerbities
acetifies1447133acetifies
acidities12810183acidities
aconites10314353aconit_es
acuities10312453a_cuities
adenines9310193adeni_nes
aerifies111313393a_erifies
affinities1645713affinities
agencies1138743agen_cies
agenizes18269743ageni_zes
agentives1346443agentives
agentries1048233agentries
agilities10810973agilities
alterities10411043alterities
alunites8310703alunit_es
amanitas1048533amanit_as
amanitin1048463amaniti_n
amebiases1343723amebiases
amenity1238333amenit__y
amentia9310153amen_ti_a
aments85219803amen_t__s
ammonifies17104083ammonifies
ammonites1348143ammonit_es
amnestied1263633amnestied
amniotes1036603am_niotes
amosites10311233amosit_es
amplifies16106703amplifies
analities9715873analities
anilities9516003anilities
annuities947463annuities
aperitifs1444413aperitifs
arenite71017713arenit_e_
aridities10911633aridities
arsenites9149163arsenit_es
asperities1249763asperities
aunties73920073a_un_ties
avidities13107613avidities
brevities1446423brevities
caninities12410493caninities
canities101519263_canities
cecities12312043_cecities
damnifies1545543dam_nifies
deities82621923_de_ities
densities10310793_densities
dignities1149593dignities
enmities10611353__enmities
entities8617413__entities
eternities1048063eternities
feminities1549673feminities
ferities111416713_ferities
galenites10129183galenit_es
gaseities1047083gase_ities
genitives1346663_genitives
humanities1547063humanities
identities1146953identities
ilmenites1146103ilmenit_es
immensities1554793immensities
immunities14116233immunities
impunities14106113impunities
inanities9312443inanities
laminitis1146243laminiti_s
laminitises1344383laminitises
latinities10410163latinities
lenites7818443_lenit_es
lenitives1247503_lenitives
levities11310713_levities
magnifies1547283magnifies
mannites10312613mannit_es
maternities1346013maternities
meinies92516073_me_inies
meninges1137433_meninges
mentees93214503_men_tees
minifies13312903_minifies
obesities1145843obesities
paternities1345783paternities
plenties10314693plen_ties
ramosities1246863ramosities
salinities10410953salinities
sanities81219773_sanities
serenities10411063serenities
sienites8311913sienit_es
syenites1138943syenit_es
temerities1268483temerities
tensities9311333_tensities
tenuities949763_tenuities
trinities9313343trinities
twenties1137503twen_ties
unities72520153__unities
vanities111414493_vanities
verities111418043_verities

Search took 7 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 Filter1786911486410.423422437.4
2DLD Change Limit1486411016.25023782.6
3Display Results1011010.0462195.7
 (SQL Overall)1786911016.71926594.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.