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

193 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
impark1428707(None) 
imbark14347861imbark
imparks15276661imparks
impart102715141impart
airpark1344922airpark
embark14458522embark
imbarks15326612imbarks
impact122310452impact
impair1036002impair
impairs1135822impairs
impala10256932impala
impale102811662impale
imparked17264862imparked
imparts11298532imparts
impawn1333262impawn
impearl1154452impearl
import102713762import
impure1038382impure
mark105138062_m_ark
park105237492__park
repark123511712repark
spark114920892_spark
airparks1443913airparks
ambari103012173ambari
ambary134010543ambary
ampere10514413ampere
apart74330673_apart
ark77044963___ark
bark106242153__bark
bipack1636523bipack
cark105539273__cark
chark144222713_chark
compare135814993compare
compart134016003compart
dark95133213__dark
debark134210943debark
demark134211023demark
depart94720563depart
dispart101115283dispart
embank14346553embank
embar94011603embar_
embarks15337353embarks
embars103812883embars
empale102611263empale
empery1348683empery
empire1039323empire
finmark16154883finmark
hark115237393__hark
image81411293im_age
imago8118693im_ago
imam81718333im_a_m
imams91511113im_ams
imaret81121233im_aret
imaum9139643im_aum
imbalm1246323imbalm
imbarked17254063imbarked
immane1038883immane
immure1036033immure
imp76626973imp___
impacts13266503impacts
impaint11511223impaint
impaired1335143impaired
impairer1244863impairer
impalas11236953impalas
impaled12288513impaled
impaler11298393impaler
impalers12226973impalers
impales113311763impales
impanel1137093impanel
imparity1546783imparity
imparking1834713imparking
imparted13248063imparted
imparter12357543imparter
impasse11246463impasse
impaste11258003impaste
impasto11275193impasto
impavid1544553impavid
impawns1433323impawns
impeach1644273impeach
impearls1253883impearls
imped105117983imp_ed
impede11469623impede
impel95711773imp_el
impels10389523impels
impend11478793impend
imperia1148423imperia
imperil1147683imperil
imphee13310353imphee
impi85415793imp__i
imping114315353imping
impis96213853imp_is
impish13499193impish
implant11311333implant
impled113812513impled
implore11176703implore
imply124911843imp_ly
impone103011863impone
imports11309623imports
impose103113053impose
impost103011783impost
improv1344643improv
imps86221123imp__s
impugn1143163impugn
impurer1136483impurer
impute1038043impute
inarm7314423i_narm
infare9313083infare
invar839513invar_
invars9310003invars
inward10310333inward
irk76426363i___rk
izar136616013i_zar_
izars145112933i_zars
izzard15135243izzard
jimper17389863jimper_
lark85733863__lark
limpa97014463limpa__
limpas105513083limpa_s
limper104117853limper_
limpers113815223limpers
maar66025063_maar_
maars74621633_maars
mack125733653_m_ack
mar57965953_m_ar_
mara67444573_m_ara
marc87034633_m_arc
mare64759333_m_are
marka114620793_m_arka
marks115933483_m_arks
marl66341623_m_arl
mars66261873_m_ars
mart66865983_m_art
mask105227363_m_ask
merk106027943_m_erk
mimbar1297493mimbar_
mimbars1397383mimbars
minipark1643543minipark
mirk106729503_m_irk
mismark1536703mismark
mispart111113783mispart
murk105527253_m_urk
nark85230063__nark
pack125535443__pack
paik105726803__paik
par57467023__par_
para65242173__para
pard76441323__pard
pare66760843__pare
parka115120883__parka
parks116134463__parks
parr65731153__parr
pars67560793__pars
part65967463__part
perk106232843__perk
pork106929683__pork
quark184614123_quark
rampart11311993rampart
remark123512373remark
repack142412163repack
reparks13249513reparks
reperk122511773reperk
sark84938973__sark
shark126225023_shark
simar74920813sim_ar_
simars84916933sim_ars
simper103616293simper_
simpers113014123simpers
smack134615453sm_ack
smarm95517603sm_arm
smart75834093sm_art
smear74416393smear_
smears84714433smears
smeary114110803smeary
smerk115412723sm_erk
smirk116612753sm_irk
snark95419943_snark
spank115919573_spank
spar65433303_spar_
spare75135563_spare
sparks124616363_sparks
sparky154511523_sparky
spars75431543_spars
squark19438113squark
stark95425623_stark
timpana11226133timpana
timpani11266153timpani
timpano11235863timpano
titlark1144723titlark
umiack1435173umiack
umiak1137673umia_k
umpire1047893umpire
unpack1457833unpack
wark115737773__wark

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 Limit1127161935.15621861.1
3Display Results1931930.0633063.5
 (SQL Overall)1786911935.60931857.9
 
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.