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

148 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
impaste1125800(None) 
impasse11246461impasse
impasted13297551impasted
impastes12238191impastes
impasto11275191impasto
impact122310452impact_
impacted15286352impacted
impacter14296572impacter
impacts13266502impacts
impale102811662impa_le
impart102715142impart_
imparted13248062imparted
imparter12357542imparter
imparts11298532imparts
impasses12257522impasses
impastoed14242802impastoed
impastos12244832impastos
impose103113052impos_e
impost103011782impost_
imposted13257402imposted
imposter12288162imposter
imposts11269002imposts
impute1038042imp_ute
paste74932952__paste
baste74829983__baste
bypast13117373bypast_
caste75932363__caste
chaste114617393_chaste
cineaste1045743cineaste
distaste939943distaste
empale102611263empa_le
haste85927863__haste
ideate7313683idea_te
image81411293im_a_ge
imamate1138103imamate
imaret81121233im_aret
imbrute1144913imbrute
imitate9310873imitate
immane1038883imma_ne
impacters15305483impacters
impactive1845283impactive
impactor14265003impactor
impaint11511223impaint
impainted1454773impainted
impaints1236243impaints
impair1036003impa_ir
impaired1335143impaired
impairer1244863impairer
impairs1135823impairs
impala10256933impa_la
impalas11236953impalas
impaled12288513impaled
impaler11298393impaler
impales113311763impales
impanel1137093impanel
imparity1546783imparity
impark14287073impa_rk
imparked17264863imparked
imparks15276663imparks
imparters13276573imparters
impassive1644243impassive
impasting1436313impasting
impavid1544553impavid
impawn1333263impa_wn
impawned1643443impawned
impawns1433323impawns
impede11469623imp_ede
imphee13310353imp_hee
impiety1445093impiety
impinge12427503impinge
impis96213853impis__
impish13499193impis_h
implant11311333implant_
implanted1475493implanted
implanter1385363implanter
implants1237883implants
implode12156103implode
implore11176703implore
impolite1249293impolite
impone103011863imp_one
import102713763import_
imported13308693imported
importer12308913importer
imports11309623imports
imposed123110293imposed
imposer113310103imposer
imposes113213683imposes
imposters13347343imposters
impostor12265483impostor
impostume1542853impostume
imposture1343663imposture
imprese1138143imprese
imprest11310203imprest_
imprests1246313imprests
improve1435963improve
imps86221123imp_s__
impulse1135113impulse
impure1038383imp_ure
imputed1236533imp_uted
imputer1136533imp_uter
imputes1138083imp_utes
incase83615283incas_e
infante101910883infante
ingate73018243inga_te
inmate82917363inma_te
innate63917313inna_te
inphase1245383inphas_e
iodate7313503ioda_te
irate55627983i_ra_te
jimpest18297553jimpest_
lambaste12145013lambaste
limbate1139213limba_te
limpas105513083limpas__
limpest113712313limpest_
lipase8239103lipas_e
masse75125293_m_asse
mast65959963_m_ast_
masted94025803_m_asted
master84831343_m_aster
masts77035763_m_asts
mate65154223_m_a_te
matte75626843_m_atte
measle83513223_measle
misate81222693misa_te
moste75925083_m_oste
pase65346863__pas_e
passe75525693__passe
past65959013__past_
pasta76624533__pasta
pasted94426903__pasted
pastel85918713__pastel
paster85734373__paster
pastes85233913__pastes
pastie85525523__pastie
pasts75936503__pasts
pasty105725053__pasty
pate65350463__pa_te
piste75824603__piste
prepaste12139083prepaste
pupate104213123pupa_te
repast83520633repast_
repasted112611533repasted
repasts93611933repasts
retaste72313133retaste
riposte9269623riposte
spate74731583_spa_te
taste55127233__taste
waste86125053__waste

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 Filter1786911340270.190940478.9
2DLD Change Limit1340271486.34321129.9
3Display Results1481480.0602466.7
 (SQL Overall)1786911486.59327103.1
 
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.