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

115 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
imposters1334734(None) 
importers13247761importers
imposers12278461impos_ers
imposter12288161imposter_
impostors13305651impostors
composters16388322composters
impacters15305482impacters
imparters13276572imparters
impastes12238192impaste_s
importer12308912importer_
imposer113310102impos_er_
imposes113213682impos_e_s
imposted13257402imposte_d
impostor12265482impostor_
imposts11269002impost__s
imposture1343662imposture
impostures1443802impostures
impowers15296822impo_wers
imputers1235822imp_uters
posters93928012__posters
apposers1236283appos_ers
bimesters1336343bim_esters
boosters104013443_boosters
composers153910623compos_ers
composter15369563composter_
costers94128333__costers
dempsters1435273demp_sters
deporters1277793deporters
deposers11359243depos_ers
disposers1238373dispos_ers
dopesters1237283dopesters
dumpsters1453743dump_sters
embossers1343413embossers
emoters94712873em_o_ters
empowers15276843empo_wers
exporters1846253exporters
exposers1736133expos_ers
fosters104220103__fosters
gypsters1434023gyp_sters
hipsters13268793hip_sters
hoopsters1445693hoopsters
imbitters13274503imbitters
imbowers15295093imbo_wers
impacter14296573impacter_
impactors15265003impactors
impairers1343713impairers
impalers12226973imp_alers
imparter12357543imparter_
impasses12257523impasse_s
impaste11258003impaste__
impasted13297553impaste_d
impastos12244833impast_os
impeders13346593imp_eders
impellers1345103impellers
impingers14284063impingers
implanters1484153implanters
implorers13124413implorers
impones112712253impo_ne_s
imported13308693importe_d
imports11309623import__s
importuners1552373importuners
impose103113053impos_e__
imposed123110293impos_e_d
impost103011783impost___
imposting1436813imposting
impostume1542853impostume
impostumes1652693impostumes
impotent1249533impo_tent
impotents1347003impo_tents
impounders1542983impounders
impower14247123impo_wer_
imprinters1444143imprinters
improvers1645043improvers
impugners14573473impugners
imputer1136533imp_uter_
imputes1138083imp_ute_s
infesters12237713infesters
inputters1143443inputters
insisters997653insisters
masters94628923_m_asters
meisters103313843_meisters
ministers1139623ministers
minsters103813923_minsters
misters93927513_m_isters
mobsters12359063_mobsters
molters93816973_m_olters
monsters103314553_monsters
mooters93818623_m_ooters
moshers124017843_m_oshers
mossers94116193_m_ossers
munsters104010553_munsters
musters94522513_m_usters
opposers1244973oppos_ers
pasters94531733__pasters
pesters93827093__pesters
porters93722703__porters
posers84223973__pos_ers
poster84129173__poster_
postern93615613__postern
posterns102713723__posterns
potters94024343__potters
pouters94221873__pouters
powters124015663__powters
reporters1139173reporters
reposers102911603repos_ers
rimesters1137483rim_esters
ripostes10239083riposte_s
roosters83514663_roosters
rosters73727543__rosters
sporters103714063_sporters
spotters104313383_spotters
spouters104011163_spouters
tapsters10318803tap_sters
tipsters10278513tip_sters
zosters163015413__zosters

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411157.32620289.5
3Display Results1151150.0462500.0
 (SQL Overall)1786911157.79522923.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.