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

179 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
mispart11111378(None) 
dispart101115281dispart
misparts12108171misparts
disparts11109952disparts
disport101015952disport
impart102715142_impart
misact10316692mis_act
miscast11312422miscast
miseat82925712misea_t
mismark1536702mismark
mispage12310522mispage
mispaint121111892mispaint
misparse1237732misparse
misparted1437262misparted
misplant12410762misplant
missort9314652missort
misstart10410042misstart
airpark1344923airpark
airport9511383airport
apart74330673__apart
biparty1445583bi_party
bistort91216523bistort
compart134016003compart
depart94720563_depart
disarm9310473dis_arm
disbar938513disbar_
disbars10310323disbars
discant103017263discant
discard11310213discard
dismast10311233dismast
disparate1249053disparate
disparity1546383disparity
disparted1338853disparted
dispirit1149193dispirit
displant11412223displant
disports111111113disports
dissert83720693dissert
distant83519953distant
distort81120333distort
emissary1343473emissary
esparto944233_esparto
gosport101010283gosport
impact122310453_impact
impark14287073_impark
imparts11298533_imparts
import102713763_import
kismat123011673kisma_t
lisper84114433lisper_
lispers94514323lispers
mart66865983m___art
mascara1138023mascara
midspace1543953midspace
migrant10314313migrant
miliary1249463miliary
milpa92111403milpa__
milpas101710273milpa_s
mimbar1297493mimbar_
mimbars1397383mimbars
minaret9520683mi_naret
minipark1643543minipark
misacts1139353mis_acts
misadapt1345203misadapt
misadd1037163mis_add
misaim10311853mis_aim
misate81222693mis_ate
misaward1464593misaward
miscall1139653miscall
miscarry1544473miscarry
miscasts1238353miscasts
miscut10614823mis_cut
misdate101413963misdate
misdealt1147983misdealt
misdraw1345623misdraw
misease92713043misease
miseats92815783miseats
misedit10311043misedit
miser75430403mis_er_
misers85025703mis_ers
misery114113543mis_ery
misfaith1644543misfaith
misfire12229893misfire
misfit112813833mis_fit
misform1437513misform
misgave13298283misgave
misgraft1447203misgraft
mishap1338873misha_p
mishaps1438723mishaps
mishear1238393mishear_
misheard1446253misheard
mishears1338323mishears
mishit112618203mis_hit
miskal123710263miska_l
miskals13369763miskals
miskept1538923miskept
mislaid1039303mislaid
mislain9311243mislain
mislay113510683misla_y
mislays12349243mislays
mislearn1045343mislearn
mislearnt1195553mislearnt
mislit83019693mis_lit
mismade12129353mismade
mismake15139373mismake
mismarks1645893mismarks
mismate111415353mismate
mismeet113215163mismeet
mismet103722373mis_met
misname11119483misname
mispaged1438243mispaged
mispages13311183mispages
mispaints13106183mispaints
misparsed1446253misparsed
misparses1347653misparses
misparting1538083misparting
mispatch1743853mispatch
mispen10312173misp_en
mispens11311073mispens
misplace1437553misplace
misplan1147773misplan
misplans1238863misplans
misplants1347313misplants
misplay1436383misplay
misplays1555543misplays
mispled12310463mispled
mispoint121012363mispoint
misprint12912973misprint
misrate91319143misrate
misreport1346053misreport
missaid10310303missaid
missal84314903missa_l
missals93914423missals
missay114112143missa_y
missays124010253missays
misseat93617243misseat
missent94318713missent
misset85028153mis_set
missorts1038323missorts
missout9412663missout
misspace1446523misspace
misspelt1247273misspelt
misspent1259173misspent
misstarts1145833misstarts
missuit9911303missuit
mist66154533mis___t
mistake131312623mistake
mister84728563mister_
misterm114314513misterm
misters93927513misters
mistral91013643mistral
misword1338413misword
miswrit1249413miswrit
muscat10314663musca_t
muskrat1346733muskrat
mustard10359533mustard
part65967463___part
piscary1437423piscary
pissant91012503pissant
rampart11311993rampart
restart7320033restart
scart76139773__scart
smart75834093__smart
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
tipcart1148833tipcart
tripart9311433tripart
unsmart939603unsmart
upstart9159753upstart
visard103910123vis_ard

Search took 10 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.423422437.4
2DLD Change Limit1340271798.98314920.1
3Display Results1791790.1431251.7
 (SQL Overall)1786911799.54918713.1
 
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.