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

146 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
impaint1151122(None) 
impaints1236241impaints
imprint11312561imprint
bepaint11312182bepaint
depaint10314592depaint
impact122310452impa_ct
impainted1454772impainted
impair1036002impai_r
impairs1135822impairs
impaling1338252impaling
impart102715142impa_rt
impatient1347752impatient
impawn1333262impawn_
impawns1433322impawns
imping114315352imp_ing
implant11311332implant
imprints1247302imprints
mispaint121111892mispaint
paint75443692__paint
repaint9318362repaint
amain74922913am_ain_
amping114317573amp_ing
appoint11612483appoint
attaint7313473attaint
bepaints1235113bepaints
complaint15410253complaint
depaints1136643depaints
dimpling14199023dimpling
dopant9316133dopa_nt
empaling1338363empaling
emptins1179403emptins
faint85837063__faint
gimping133710763gimp_ing
haint85436323__haint
imagine1037883imagine
imaging1138083imaging
imagist1077333imagist
imaret81121233im_aret
imbuing1236103imbuing
imine75821063im__ine
imino74315233im__ino
immane1038883imma_ne
immanent1246803immanent
impacting1635943impacting
impacts13266503impacts
impainting1544503impainting
impaired1335143impaired
impairer1244863impairer
impairing1445473impairing
impairment1644683impairment
impala10256943impa_la
impalas11236953impalas
impale102811663impa_le
impaled12288513impaled
impaler11298393impaler
impales113311763impales
impanel1137093impanel
imparity1546783imparity
impark14287073impa_rk
imparking1834713imparking
imparks15276663imparks
imparting1437243imparting
imparts11298533imparts
impasse11246463impasse
impaste11258003impaste
impasting1436323impasting
impasto11275193impasto
impatiens1345733impatiens
impavid1544553impavid
impawned1643443impawned
impawning1743423impawning
impeding1436563impeding
impend11478793imp_end
impi85415793imp_i__
impiety1445093imp_iety
impinge12427503imp_inge
impings12348553imp_ings
impis96213853imp_i_s
impish13499193imp_ish
implants1237883implants
implicit1446813implicit
implied1238623implied
implies11312123implies
implying1635533implying
impone103011863imp_one
imponing1338773imponing
import102713763imp_ort
imposing1348463imposing
impost103011783imp_ost
impotent1249533impotent
impound1235393impound
imprest11310203imprest
imprinted1445753imprinted
imprinter1385243imprinter
impudent1346283impudent
impugn1143163impugn_
impugns1243333impugns
impunity1544653impunity
imputing1336853imputing
incant82418513inca_nt
infant92315133infa_nt
inpatient1147653inpatient
limping124614113limp_ing
limpkin1534223limpkin_
limpkins1644233limpkins
main65345523_m_ain_
mains75635113_m_ains
maist75535683_m_aist
meant76537213_mea_nt
midpoint13117493midpoint
mint66758073_m__int
mispaints13106183mispaints
mispoint121012363mispoint
misprint12912973misprint
outpaint10311773outpaint
pain65647243__pain_
pains75138283__pains
paints85921833__paints
painty114714753__painty
pant66061263__pa_nt
papain10313793papain_
papains11312373papains
pimping143812123pimp_ing
pinpoint1248993pinpoint
pint66963183__p_int
plaint85323203_plaint
point75338733__point
print74837463__print
quaint15415173_quaint
rampant11312173rampa_nt
repaints1038483repaints
reprint9318983reprint
rimpling13219663rimpling
saint55147073__saint
simplist12249683simplist
spait75631603_spai_t
splint85223283_splint
sprint84526793_sprint
taint55542283__taint
timpana11226133timpa_na
timpani11266153timpa_ni
timpanist1345373timpanist
timpano11235863timpa_no
umping114815333ump_ing
wimping153911013wimp_ing
wimpling16207483wimpling

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.390458182.1
2DLD Change Limit1340271466.12621878.4
3Display Results1461460.0463173.9
 (SQL Overall)1786911466.56227231.2
 
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.