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

157 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
impasted1329755(None) 
impacted15286351impacted
imparted13248061imparted
impaste11258001impaste_
impastes12238191impastes
impastoed14242801impastoed
imposted13257401imposted
impacter14296572impacter
impainted1454772impainted
impaired1335142impaired
impaled12288512impa_led
imparked17264862imparked
imparter12357542imparter
impasse11246462impasse_
impasses12257522impasses
impasto11275192impast_o
impastos12244832impastos
impawned1643442impawned
implanted1475492implanted
imported13308692imported
imposed123110292impos_ed
imposter12288162imposter
imputed1236532imp_uted
masted94025802_m_asted
pasted94426902__pasted
repasted112611532repasted
amassed10388633am_assed
basted95227233__basted
biparted1335133biparted
blasted104213473_blasted
boasted104113743_boasted
breasted1138823breasted
bypassed1642713bypassed
coasted104015963_coasted
compacted18297363compacted
comparted16338423comparted
compassed1645543compassed
composted16378823composted
demasted1238763demasted
departed1238823departed
dismasted1346833dismasted
disparted1338853disparted
distasted1137963distasted
empaled12288953empa_led
fasted105320953__fasted
feasted11310843_feasted
gasted84821583__gasted
hasted105125283__hasted
ideated9310973idea_ted
imaged1097763im_a_ged
imbalmed1543293imbalmed
imbarked17254063imbarked
imbruted1343693imbruted
imitated1138263imitated
immeshed1643433immeshed
impact122310453impact__
impacters15305483impacters
impactor14265013impactor
impacts13266503impact_s
impairer1244863impairer
impale102811663impa_le_
impaler11298393impa_ler
impales113311763impa_les
impanel1137093impa_nel
impaneled1443563impaneled
impart102715143impart__
imparters13276573imparters
imparts11298533impart_s
impasting1436323impasting
impavid1544553impa_vid
impeached1942983impeached
impearled1442863impearled
imped105117983imp___ed
impeded13418183imp_eded
impelled1336073impelled
impended1435953impended
impinged14275123impinged
implanter1385363implanter
impled113812513imp__led
implied1238623imp_lied
imploded14145073imploded
implored13135373implored
imponed12279453imp_oned
importer12308913importer
impose103113053impos_e_
imposer113310103impos_er
imposes113213683impos_es
impost103011783impost__
imposters13347343imposters
impostor12265483impostor
imposts11269003impost_s
impressed1446283impressed
imprinted1445753imprinted
improved1644773improved
impugned14333923impugned
impulsed1334003impulsed
impute1038043imp_ute_
imputer1136533imp_uter
imputes1138083imp_utes
incanted11259543incanted
incased103612393incas_ed
infested12249643infested
ingested10259003ingested
inputted1134663inputted
insisted998673insisted
invested12229693invested
iodated9310023ioda_ted
lambasted14103253lambasted
lasted74323603__lasted
malted94819863_m_alted
marted94425213_m_arted
mashed125325043_m_ashed
masked134316523_m_asked
massed94421323_m_assed
master84831343_m_aster
mated85537783_m_a_ted
matted94521413_m_atted
measled10339303_measled
meated94222403_mea_ted
misacted1338673misacted
misparted1437263misparted
misted93625823_m_isted
moated94819003_moa_ted
musted93321073_m_usted
panted95024823__panted
parted94228683__parted
pashed125923143__pashed
passed94320943__passed
paste74932953__paste_
pastel85918713__pastel
paster85734373__paster
pastes85233913__pastes
pated85237843__pa_ted
patted94724683__patted
posted93722493__posted
prepasted14137673prepasted
pupated12319353pupa_ted
ramparted1443543ramparted
repassed11229273repassed
retasted92412113retasted
riposted11216943riposted
roasted83912673_roasted
smarted105012613sm_arted
smashed133711223sm_ashed
spasmed12296993_spasmed
spatted104014143_spatted
tasted74123973__tasted
tempested1444033tempested
toasted84011923_toasted
umlauted1132823umlauted
unbasted112510073unbasted
unparted11310823unparted
unposted1159433unposted
untasted92011573untasted
unwasted12259783unwasted
wasted104423023__wasted
yeasted1138503_yeasted

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621576.97020970.2
3Display Results1571570.0632492.1
 (SQL Overall)1786911577.46923924.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.