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

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

144 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
impersonations186365(None) 
impersonation1764221impersonation_
impersonating1873202impersonati_ng
impersonators1792492impersonat_ors
personations1448392__personations
impersonalizes2762883impersonalizes
impersonates1653893impersonat__es
impersonator1692733impersonat_o_r
impregnations1853773imp_regnations
personation1349483__personation_
impartations16135434impar__tations
imperfections2254004imper_fections
impersonalities1963674impersonalities
impersonality2063604impersonali_ty
impersonalize2663074impersonali_ze
impersonalized2862544impersonalized
impersonalizing2962184impersonalizing
impersonate1554364impersonat___e
impersonated1763274impersonat__ed
impetrations1645444impe__trations
importations16156144impor__tations
imprecations1846274imp_r_ecations
impregnation1754014imp_regnation_
interpolations1657434interpolations
interrogations1556814interrogations
percolations1648054__percolations
perennations1447254__perennations
perforations1747874__perforations
perorations13314064__per_orations
personating1447674__personati_ng
personators1345544__personat_ors
pronations12314034__p_r_onations
supernations14410874super__nations
superstations15208144supers_tations
alternations1246775alter__nations
ameliorations1563195am_eliorations
approbations1854245_appr_obations
carbonations1644845__carbonations
compensations19136185compens__ations
coronations13410705__cor_onations
cybernations1943605cyber__nations
decarbonations19123155decarbonations
depersonalizes26113285depersonalizes
derogations1349395__der_ogations
desolations12310595__de_solations
deteriorations15164695deteriorations
determinations1766895determinations
detonations1239375__de_tonations
dimerizations2548545dim_er_izations
dispensations1655485dispens__ations
emarginations1674155em_arginations
embrocations1843985em_br_ocations
expectorations2552195expectorations
exterminations2365125exterminations
germinations15137945__germinations
hibernations1744055hiber__nations
hyperfunctions2762665hyperfunctions
imaginations1546345im__aginations
imbrications1845685im_br_ications
immersions1444005immers____ions
immolations1545475im___molations
impartation15156105impar__tation_
imperatives1846445imper___atives
imperators1447715imper___at_ors
imperfection2154045imper_fection_
impersonal1454745impersona____l
impersonally1953905impersona__lly
impetration1545905impe__tration_
implantations1753245imp_lantations
implementations2162885implementations
implications1847025imp__lications
importation15147125impor__tation_
impositions1546035imp___ositions
imprecation1746545imp_r_ecation_
impregnating1852845imp_regnati_ng
impregnators1752535imp_regnat_ors
impresarios1552375impres__ario_s
impressions1546825impres___sions
improvisations2152535improvisations
imputations1546355imp___utations
incardinations1754415incardinations
incarnations1446665incar__nations
incorporations18134855incorporations
infestations1546625infe_s_tations
innervations1546925inner__vations
inseminations1546245inse_minations
insolations1149185i___nsolations
intercalations1655915intercalations
interlineations1554545interlineations
interpolation1558555interpolation_
interpositions1685125interpositions
interrelations1457615interrelations
interrogation1457865interrogation_
intersections1598965inters_ections
interstation12410415inters_tation_
interventions1657515interven_tions
intonations1149525i___ntonations
irresolutions13162375irre_solutions
isolations10310695i____solations
iterations10413825i_ter___ations
marginations1546455_m_arginations
marinations13411275_m_ar_inations
meliorations1466755_m_eliorations
mensurations1445715_m_ensurations
mercurations1646565_m_ercurations
methanations1743975_m_ethanations
operations12312955_oper___ations
pectinations1649255__pectinations
percolation1549225__percolation_
perennation1348085__perennation_
perforation1649005__perforation_
permeations1549885__per_meations
permutations1646505__permutations
peroration12316005__per_oration_
persecutions1654795__persecutions
personalises1476525__personalises
personalisms1676095__personalisms
personalists1476505__personalists
personalizes2356705__personalizes
personalties1485155__personalti_es
personates122510695__personat__es
personative1647075__personati_ve
personator1245855__personat_o_r
perspirations1786175__perspirations
persuasions1383915__pers_uasions
phonations1538315__p__honations
premonitions1646855__premonitions
presentations1548135__presentations
probations14311085__p_r_obations
pronation11415705__p_r_onation_
prorations12314465__p_r_orations
protonations1449075__protonations
representations17153895representations
reprobations1647775rep_r_obations
superannuations1763805superannuations
supererogations1862835supererogations
superfetations1975065superfetations
supernation13411665super__nation_
superpositions18145265superpositions
superstation14168625supers_tation_
superstitions15176785supers_titions
superventions18125785superven_tions
terminations14149765__terminations
vernations13310335__ver__nations

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 Filter178691950240.393454684.5
2DLD Change Limit950241446.09315595.6
3Display Results1441440.0931548.4
 (SQL Overall)1786911446.57927160.8
 
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.