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

136 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
imposter1228816(None) 
importer12308911importer
imposer113310101impos_er
imposted13257401imposted
imposters13347331imposters
impostor12265481impostor
composter15369562composter
impacter14296572impacter
imparter12357542imparter
impaste11258002impaste_
impasted13297552impasted
impastes12238192impastes
imported13308692imported
importers13247762importers
impose103113052impos_e_
imposed123110292impos_ed
imposers12278452impos_ers
imposes113213682impos_es
impost103011782impost__
impostors13305632impostors
imposts11269002impost_s
imposture1343652imposture
impower14247122impo_wer
imputer1136532imp_uter
poster84129172__poster
apposer1147483appos_er
bimester1236163bim_ester
booster94314553_booster
composer145012953compos_er
composted16378813composted
composters16388313composters
coster84331293__coster
dempster1355773demp_ster
deporter1169393deporter
deposer104011843depos_er
disposer11310403dispos_er
dopester1137253dopester
dumpster1344053dump_ster
embosser1244283embosser
emoter85415193em_o_ter
empower14217033empo_wer
exporter1737363exporter
exposer1637413expos_er
foster94322223__foster
gypster1333953gyp_ster
hipster12288783hip_ster
hoopster1335543hoopster
imbitter12265283imbitter
imbower14235663imbo_wer
impacted15286353impacted
impacters15305473impacters
impactor14265003impactor
impairer1244863impairer
impaler11298393imp_aler
imparted13248063imparted
imparters13276563imparters
impasse11246463impasse_
impasses12257523impasses
impasto11275193impast_o
impastoed14242803impastoed
impastos12244833impastos
impeder12438533imp_eder
impeller1236083impeller
impinger13315423impinger
implanter1385363implanter
implorer12125103implorer
impolite1249293impolite_
impone103011863impo_ne_
imponed12279453impo_ned
impones112712253impo_nes
import102713763import__
imports11309623import_s
importuner1452683importuner
imposing1348463imposing
imposting1436813imposting
impostume1542853impostume
impostumes1652693impostumes
impostures1443793impostures
impotent1249533impo_tent
impounder1443713impounder
impowers15296823impo_wers
imprinter1385243imprinter
improper1444533improper
improver1545243improver
impugner13444233impugner
impurer1136483imp_urer
impute1038043imp_ute_
imputed1236533imp_uted
imputers1235813imp_uters
imputes1138083imp_utes
infester11239433infester
inputter1034203inputter
insister888783insister
limpsier1234433limp_sier
master84831343_m_aster
meister93114163_meister
minister10410363minister
minster93914323_minster
mister84728563_m_ister
mobster11299213_mobster
moister94015373_moister
molter84119423_m_olter
monster93214593_monster
mooter83921093_m_ooter
mosher114719793_m_osher
mosser84618273_m_osser
moste75925083_m_oste_
munster93710523_munster
muster84724523_m_uster
opposer1135773oppos_er
paster85734373__paster
pester84827593__pester
porter84224413__porter
poser75128773__pos_er
posher115018163__posher
posted93722493__posted
postern93615603__postern
posters93927993__posters
potter83926983__potter
pouter83923983__pouter
powter114116033__powter
reporter10411423reporter
reposer93715333repos_er
rimester1037813rim_ester
riposte9269623riposte_
riposted11216933riposted
ripostes10239083ripostes
rooster74415173_rooster
roster64329083__roster
sporter93616553_sporter
spotter94514873_spotter
spouter94213223_spouter
tapster9299273tap_ster
tipster9299053tip_ster
unposted1159433unposted
zoster153715853__zoster

Search took 9 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.1601116818.8
2DLD Change Limit1461621368.59317009.4
3Display Results1361360.0462956.5
 (SQL Overall)1786911368.79920308.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.