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

189 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
impact12231045(None) 
impacts13266501impacts
impart102715141impart
compact153712212compact
epact94921532_epact
impacted15286352impacted
impacter14296572impacter
impactor14265002impactor
impaint11511222impaint
impair1036002impair
impala10256932impala
impale102811662impale
impark14287072impark
imparts11298532imparts
impaste11258002impaste
impasto11275192impasto
impawn1333262impawn
impeach1644272impeach
implant11311332implant
import102713762import
impost103011782impost
intact8314662intact
misact10316682misact
pact86648722__pact
act59557843___act
alpaca1047383alpaca
apace94718383_apace
apart74330673_apart
aspect10612823aspect
bipack1636523bipack
bract96332723_bract
bypast13117373bypast
coact96130583_coact
compacts16368903compacts
compart134016003compart
depart94720563depart
depict113514793depict
didact10711203didact
dispart101115283dispart
dopant9316133dopant
empale102611263empale
emplace1338263emplace
enact73525363_enact
epacts105010393_epacts
exact143516933_exact
expat14313813expa_t
expect1758903expect
fact97142543__fact
hepcat13611823hepcat
ikat87626643i_ka_t
ileac75814173ileac_
iliac75013493iliac_
image81411293im_age
imago8118693im_ago
imam81718333im_a_m
imams91511113im_ams
imaret81121233imaret
imaum9139643im_aum
imbalm1246323imbalm
imbark14347863imbark
immane1038883immane
imp76626973imp___
impacters15305483impacters
impactful1851753impactful
impacting1635943impacting
impaction1545733impaction
impactive1845283impactive
impactors15265003impactors
impaints1236243impaints
impairs1135823impairs
impalas11236953impalas
impaled12288513impaled
impaler11298393impaler
impales113311763impales
impanel1137093impanel
imparity1546783imparity
imparks15276663imparks
imparted13248063imparted
imparter12357543imparter
impasse11246463impasse
impasted13297553impasted
impastes12238193impastes
impastos12244833impastos
impavid1544553impavid
impawns1433323impawns
impearl1154453impearl
imped105117983imp_ed
impede11469623impede
impel95711773imp_el
impels10389523impels
impend11478793impend
imphee13310353imphee
impi85415793imp__i
impiety1445093impiety
imping114315353imping
impis96213853imp_is
impish13499193impish
implants1237883implants
impled113812513impled
implicit1446813implicit
imply124911843imp_ly
impone103011863impone
imports11309623imports
impose103113053impose
imposts11269003imposts
imprest11310203imprest
imprint11312563imprint
improv1344643improv
imps86221123imp__s
impugn1143163impugn
impure1038383impure
impute1038043impute
inapt73522693i_napt
incant82418503incant
incompact1754353incompact
indict93115573indict
induct93212743induct
inexact1647413inexact
infant92315133infant
infarct1249013infarct
infect113413443infect
infract12610003infract
inject153210233inject
inlace82513043inlace
input7314653inp_ut
insect83916583insect
inspect1138463inspect
isopach1444243isopach
jimpest18297553jimpest
limpa97014463limpa__
limpas105513083limpa_s
limpest113712313limpest
limpet103518633limp_et
mac78053933_m_ac_
mace87345793_m_ace
mach116134483_m_ach
mack125733653_m_ack
macs86742513_m_acs
malt66254813_m_alt
mart66865983_m_art
mast65959963_m_ast
mat58083943_m_a_t
matt65752663_m_att
maut65448453_m_aut
meant76537213_meant
meat66359603_mea_t
misacts1139353misacts
mispart111113773mispart
moat66352033_moa_t
mulct93820083_mulct
nonimpact1553033nonimpact
outact8317203outact
pac79054083__pac_
paca85132243__paca
pace86345773__pace
pack125535443__pack
pacs85842183__pacs
pacts95125803__pacts
pacy115328683__pacy
pant66061263__pant
papacy1547493papacy
part65967463__part
past65959013__past
pat58089463__pa_t
preact103220393preact
rampant11312173rampant
rampart11311993rampart
react74634333_react
redact9419043redact
repack142412163repack
repast83520633repast
smack134615453sm_ack
smalt74729333sm_alt
smart75834093sm_art
space95325673_space
spacy125415623_spacy
spait75631603_spait
spat66548523_spa_t
tact67349033__tact
timpana11226133timpana
timpani11266153timpani
timpano11235863timpano
tipcat10312653tipcat
tract75635713_tract
umiac938963umiac_
umiack1435173umiack
umiacs1035663umiacs
umlaut838033umlaut
unpack1457833unpack

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127161894.64024292.2
3Display Results1891890.0633000.0
 (SQL Overall)1786911895.07935182.3
 
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.