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

256 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
impart10271514(None) 
impact122310451impact
impark14287071impark
imparts11298531imparts
import102713761import
apart74330672_apart
compart134016002compart
depart94720562depart
dispart101115282dispart
imaret81121232im_aret
imbark14347862imbark
impacts13266502impacts
impaint11511222impaint
impair1036002impair
impairs1135822impairs
impala10256932impala
impale102811662impale
imparity1546782imparity
imparks15276662imparks
imparted13248062imparted
imparter12357542imparter
impaste11258002impaste
impasto11275192impasto
impawn1333262impawn
impearl1154452impearl
implant11311332implant
imports11309622imports
impost103011782impost
impure1038382impure
mart66865972_m_art
mispart111113772mispart
part65967462__part
rampart11311992rampart
smart75834092sm_art
airpark1344923airpark
airport9511383airport
ambari103012163ambari
ambary134010543ambary
amort75832203am_ort
ampere10514413ampere
aport75432173_aport
apparat11711713apparat
art38679143___art
biparty1445583biparty
boart78835933_boart
bogart9617193bogart
bypast13117373bypast
cart66570343__cart
chart105038283_chart
compact153712213compact
compare135814993compare
comparts144210833comparts
comport133616843comport
dart55857873__dart
departs104310683departs
deport94922393deport
disparts11109953disparts
disport101015953disport
dopant9316133dopant
dumpcart1543463dumpcart
embar94011603embar_
embark14458523embark
embars103812883embars
empale102611263empale
empery1348683empery
empire1039323empire
epact94921533_epact
esparto944233esparto
expat14313813expa_t
expert15515353expert
export15412183export
fart76860563__fart
hart76865773__hart
heart85440743_heart
ikat87626643i_ka_t
image81411293im_age
imago8118693im_ago
imam81718333im_a_m
imams91511113im_ams
imarets9138643im_arets
imaum9139643im_aum
imbalm1246323imbalm
imbarks15326613imbarks
immane1038883immane
immure1036033immure
imp76626973imp___
impacted15286353impacted
impacter14296573impacter
impactor14265003impactor
impaints1236243impaints
impaired1335143impaired
impairer1244863impairer
impalas11236953impalas
impaled12288503impaled
impaler11298393impaler
impalers12226963impalers
impales113311763impales
impanel1137093impanel
imparked17264863imparked
imparters13276563imparters
impartial1345183impartial
imparting1437243imparting
impasse11246463impasse
impasted13297553impasted
impastes12238193impastes
impastos12244833impastos
impavid1544543impavid
impawns1433323impawns
impeach1644273impeach
impearls1253883impearls
imped105117983imp_ed
impede11469623impede
impel95711773imp_el
impels10389523impels
impend11478793impend
imperia1148423imperia
imperil1147683imperil
imphee13310353imphee
impi85415793imp__i
impiety1445093impiety
imping114315353imping
impis96213853imp_is
impish13499193impish
implants1237883implants
impled113812513impled
implore11176703implore
imply124911843imp_ly
impone103011863impone
imported13308693imported
importer12308913importer
impose103113053impose
imposts11269003imposts
imprest11310203imprest
imprint11312563imprint
improv1344643improv
imps86221123imp__s
impugn1143163impugn
impurer1136483impurer
impurest1245913impurest
impurity1544763impurity
impute1038043impute
inapt73522693i_napt
inarm7314423i_narm
incant82418503incant
inearth1037033inearth
inert53234373i_nert
infant92315133infant
infarct1249013infarct
infare9313083infare
input7314653inp_ut
insert64325253insert
intact8314663intact
intort6418923intort
invar839513invar_
invars9310003invars
invert94120083invert
inward10310333inward
izar136616013i_zar_
izars145112933i_zars
izzard15135243izzard
jimper17389863jimper_
jimpest18297553jimpest
kart86750803__kart
limpa97014463limpa__
limpas105513083limpa_s
limper104117853limper_
limpers113815223limpers
limpest113712313limpest
limpet103518633limp_et
lyart85121883_lyart
maar66025053_maar_
maars74621633_maars
malt66254803_m_alt
mar57965943_m_ar_
mara67444563_m_ara
marc87034623_m_arc
mare64759323_m_are
mark105138053_m_ark
marl66341613_m_arl
mars66261863_m_ars
marts77442233_m_arts
mast65959953_m_ast
mat58083933_m_a_t
matt65752653_m_att
maut65448443_m_aut
meant76537203_meant
meat66359603_mea_t
mimbar1297493mimbar_
mimbars1397383mimbars
minaret9520683minaret
misact10316683misact
misparts12108173misparts
moat66352033_moa_t
mort66758833_m_ort
nonart6319193nonart
oxcart1539523oxcart
pact86648723__pact
pant66061253__pant
par57467023__par_
para65242173__para
pard76441323__pard
pare66760843__pare
park105237493__park
parr65731153__parr
pars67560793__pars
parts77743373__parts
party106630613__party
past65959013__past
pat58089463__pa_t
peart76440753_peart
pert66759323__pert
port66059633__port
prat65952043__prat
quart144027853_quart
rampant11312173rampant
ramparts1245583ramparts
reimport1246503reimport
repark123511713repark
repast83520633repast
report85326013report
scart76139773_scart
simar74920813sim_ar_
simars84916933sim_ars
simper103616293simper_
simpers113014113simpers
smalt74729333sm_alt
smarm95517603sm_arm
smarts86218003sm_arts
smarty115013793sm_arty
smear74416393smear_
smears84714433smears
smeary114110803smeary
spait75631603_spait
spar65433303_spar_
spare75135563_spare
spark114920893_spark
spars75431543_spars
spat66548523_spa_t
spirt75032953_spirt
sport75935983_sport
sprat76635973_sprat
spurt77227983_spurt
start55642313_start
subpart11311123subpart
swart86234643_swart
tart47566183__tart
thwart12311683thwart
timpana11226123timpana
timpani11266143timpani
timpano11235863timpano
tipcart1148833tipcart
tripart9311433tripart
umlaut838033umlaut
umpire1047893umpire
updart9310743updart
wart77866083__wart

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 Filter1786911127160.266671770.7
2DLD Change Limit1127162566.62617011.2
3Display Results2562560.1232081.3
 (SQL Overall)1786912567.01525472.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.