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

122 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
impawn133326(None) 
impawns1433321impawns
impact122310452impact
impaint11511222impaint
impair1036002impair
impala10256932impala
impale102811662impale
impark14287072impark
impart102715142impart
impawned1643442impawned
impugn1143162impugn
mawn94424142_m_awn
pawn94625302__pawn
spawn107811712_spawn
amain74922913am_ain
awn68035913___awn
blawn106813703_blawn
brawn106018563_brawn
dawn85624203__dawn
drawn95614243_drawn
empale102611263empale
fawn105321953__fawn
gnawn9517783_gnawn
image81411293im_age
imago8118693im_ago
imam81718333im_a_m
imams91511113im_ams
imaum9139643im_aum
imbalm1246323imbalm
imbark14347863imbark
imbrown1443883imbrown
immane1038883immane
imp76626973imp___
impacts13266503impacts
impaints1236243impaints
impairs1135823impairs
impalas11236953impalas
impaled12288513impaled
impaler11298393impaler
impales113311763impales
impaling1338253impaling
impanel1137093impanel
imparks15276663imparks
imparts11298533imparts
impasse11246463impasse
impaste11258003impaste
impasto11275193impasto
impavid1544553impavid
impawning1743423impawning
impeach1644273impeach
impearl1154453impearl
imped105117983imp_ed
impede11469623impede
impel95711773imp_el
impels10389523impels
impend11478793impend
imphee13310353imphee
impi85415793imp__i
imping114315353imping
impis96213853imp_is
impish13499193impish
implant11311333implant
impled113812513impled
imply124911843imp_ly
impone103011863impone
import102713763import
impose103113053impose
impost103011783impost
impound1235393impound
impower14247123impower
impregn1243403impregn
imprint11312563imprint
improv1344643improv
imps86221123imp__s
impugns1243333impugns
impure1038383impure
impute1038043impute
indrawn1145093indrawn
inspan837513inspa_n
intown936153intown
japan14411233japa_n
jigsawn1841583jigsawn
lawn75925633__lawn
liman75921603lim_a_n
limpa97014463limpa__
limpas105513083limpa_s
limpkin1534223limpkin
main65345523_m_ain
man57465873_m_a_n
maun65727213_m_aun
maw87050103_m_aw_
maws96437143_m_aws
mean65538093_mea_n
moan65832023_moa_n
mown95424443_m_own
pain65647243__pain
pan58466453__pa_n
papain10313793papain
papaw125112493papaw_
papaws13419113papaws
paw87651173__paw_
pawl95123263__pawl
pawns108818133__pawns
paws96038183__paws
prawn105312433_prawn
resawn9399953resawn
ripsawn1242503ripsawn
sampan102511893sampa_n
sawn75428163__sawn
shawn116417613_shawn
simian8811163simia_n
span65234663_spa_n
spawns11577923_spawns
tampan102512323tampa_n
thrawn12769423thrawn
timpana11226133timpana
timpani11266153timpani
timpano11235863timpano
tympan13257013tympa_n
ulpan7310123ulpa_n
unsawn9317463unsawn
yawn106219093__yawn

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.390458182.1
2DLD Change Limit1127161224.79623502.1
3Display Results1221220.0333697.0
 (SQL Overall)1786911225.21934238.6
 
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.