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

199 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
mismade1212935(None) 
mismake15139371mismake
mismate111415351mismate
manmade1237962manmade
misadd1037162mis_add
misate81222692mis_ate
miscode12310412miscode
misdate101413962misdate
misease92713042misease
misgave13298282misgave
misgrade1247502misgrade
mismakes16129882mismakes
mismark1536702mismark
mismated131111332mismated
mismates121114562mismates
mismove1437082mismove
misname11119482misname
mispage12310522mispage
misrate91319142misrate
mistake131312622mistake
bistate9313823bistate
camisade1374823camis_ade
cascade12118603cascade
chamade15138453chamade
comade114415323_comade
diamide1138473diamide
discase102912863discase
disease83213843disease
dismal92412243disma_l
dismaler1137903dismaler
dismals102010243dismals
dismast10311233dismast
dismay12229473disma_y
dismayed1535743dismayed
dismays13237433dismays
disme85716243dism__e
disrate81418523disrate
dissave1139413dissave
dissuade1065933dissuade
fissate103010033fissate
glissade1043193glissade
image81411293_i_mage
imamate1138103imamate
imide85716893_i_mide
immane1038883_immane
inmate82917363_inmate
invade10157853_invade
irade65618153_i_rade
kismat123011673kisma_t
kismats13257843kismats
limeade1076123limeade
made75440243___made
mammae94613213mamma_e
mammate104411273mammate
massage1039893massage
message1037833message
messmate1246393messmate
miasma1097563miasma__
miasmal1176743miasma_l
miasmas1167743miasma_s
miasmata1244503miasmata
midspace1543953midspace
migrate101314173migrate
mikado1344513mi_kado
miladi938883mi_ladi
milady1236613mi_lady
milage93414123mi_lage
mileage10299313mileage
millage103112753millage
mime85736403mi_m__e
mimed105622733mi_med_
minae75627723mi_na_e
mintage101110123mintage
mirage92313653mi_rage
misact10316683mis_act
misadded1335753misadded
misadds1136303misadds
misaim10311853mis_aim
misaver1249813mis_aver
miscall1139643miscall
miscast11312413miscast
miscite11314383miscite
miscoded1437983miscoded
miscodes13310423miscodes
miscue10412223mis_cue
miscued1239293miscued
misdated121211123misdated
misdates111113633misdates
misdeed113211053misdeed
misdid10510573misdid_
misdo85413183mis__do
misdone10310863misdone
mise66043583mis___e
miseases102614343miseases
miseat82925703misea_t
miseaten10310773miseaten
miseats92815783miseats
misfed124113023misfed_
misfeed13389683misfeed
misfile122611553misfile
misfire12229893misfire
misframe1546973misframe
misgauge1244253misgauge
misgive13339033misgive
misgraded1446233misgraded
misgrades1347363misgrades
misguide12145703misguide
mishandle1544223mishandle
mishap1338863misha_p
mishaps1438713mishaps
mishmash18133433mishmash
misjudge1942613misjudge
miskal123710263miska_l
miskals13369763miskals
mislabel1296173mislabel
mislaid1039303mislaid
mislain9311243mislain
mislay113510683misla_y
mislayer1337503mislayer
mislays12349243mislays
mislead10419973mislead_
misleader1246503misleader
misleads11358543misleads
misled94719313misled_
mislie83219153mis_lie
mislike132914833mislike
mislive122812693mislive
mislodge1244113mislodge
mismanage1444153mismanage
mismarked1845243mismarked
mismarks1645893mismarks
mismatch1743943mismatch
mismeet113215163mismeet
mismet103722373mism_et
mismoved1635653mismoved
mismoves1537293mismoves
misnamed13127593misnamed
misnames12119883misnames
misorder1147283misorder
mispaged1438243mispaged
mispages13311183mispages
misparse1237733misparse
mispart111113773mispart
misplace1437553misplace
mispled12310463mispled
misraise10410523misraise
misrated111315383misrated
misrates101318243misrates
misread10339723misread_
misreads11268923misreads
misrule939353misrule
missable12311533missable
missaid10310303missaid
missal84314903missa_l
missals93914423missals
missay114112143missa_y
missays124010253missays
missed94423603missed_
misshape1545973misshape
missile92815403missile
missive122413143missive
misspace1446523misspace
misstate10711343misstate
mistaken14147833mistaken
mistaker14109333mistaker
mistakes141213413mistakes
misted93625823misted_
mistime11312613mistime
mistrace12312643mistrace
mistune9310653mistune
mistype14126523mistype
misusage1145173misusage
misuse83213643mis_use
misused104111283misused
misvalue1344683misvalue
misyoke1635823misyoke
muscadel1343763muscadel
muscadet1348143muscadet
muscae10410673musca_e
passade1039233passade
pesade9311103pes_ade
pismire1135353pismire
pomade113611333_pomade
premade12311443premade
remade94316983_remade
respade1039573respade
sade55544473__s_ade
shade95125583__shade
sigmate10710143sigmate
smaze165012933__smaze
spade84423323__spade
stade64825303__stade
tirade7311693ti_rade
tisane6311573tis_ane
tsade64311123_ts_ade
unmade92911063_unmade
visaed104110503vis_aed
visage1049083vis_age
vistaed1138023vistaed

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 Limit1340271995.78023188.1
3Display Results1991990.0802487.5
 (SQL Overall)1786911996.25028590.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.