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

268 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
misdoer104863(None) 
misdoers1137101misdoers
misdoes10312491misdoes
middler112712272middler
milder93818452mild_er
minder94822502mind_er
misaver1249812misaver
misdeed113211052misdeed
misdeem12217872misdeem
misdo85413182misdo__
misdone10310862misdone
misdrew1335832misdrew
miser75430402mis__er
misnomer1247142misnomer
mister84728562mis_ter
mistier93418712mistier
misuser93210442misuser
aider65431133ai_d_er
bidder104114863bi_dder
bider85728373bi_d_er
binder94422873bind_er
birder94915493bird_er
bister84922763bis_ter
cider84723313ci_d_er
cinder94119123cind_er
ciscoes113610733ciscoes
diddler103511513diddler
didoes85716963di_does
dildoe8198673dildoe_
dildoes9229243dildoes
discoed11312483discoed
discover1439563discover
dishier113613403dishier
disposer11310413disposer
disrober1147623disrober
doer57734703___doer
eider64624743ei_d_er
evildoer1241933evildoer
fiddler12309953fiddler
finder104020233find_er
fisher124917143fis_her
fishier13359853fishier
giddier10308723giddier
gilder84415533gild_er
girder84312063gird_er
girdler9227313girdler
hider95024083hi_d_er
hinder104120063hind_er
hisser94713793his_ser
hissier103410503hissier
idler65015663_i_dler
indoor738403_indoor
isomer8310153_isomer
issuer646623_issuer
kidder123811103ki_dder
kiddoes13387063kiddoes
kinder113716843kind_er
kindler12309983kindler
kisser104212453kis_ser
lassoer7379383lassoer
lieder74912323lied_er
lisper84114433lis_per
lister64527253lis_ter
madder103515593m_adder
maser75029973mas__er
masher114123203mas_her
masker124416103mas_ker
masquer18266463masquer
massier93615223massier
master84831343mas_ter
meddler11319953meddler
meister93114163meis_ter
melder93915813meld_er
mender93520793mend_er
meshier123410853meshier
mesoderm1344493mesoderm
messier93412923messier
mickler153310233mickler
midair937993mi_dair
midden104112853mi_dden
middies113116153middies
middle103414983middle_
middled123311903middled
middlers123410193middlers
middles113415303middles
midge95016553mi_dge_
midges103516483mi_dges
midget103718453mi_dget
midleg1038553mi_dleg
midsole1037813midsole
midsoles1137763midsoles
midterm12316013mi_dterm
midyear1343343mi_dyear
miffier1537023miffier
milded104416153mild_ed
milden94113153mild_en
mildew12319043mild_ew
miler75733063mi__ler
milker124814323mi_lker
milkier133411163milkier
miller84625413mi_ller
millier93716703millier
milter84921233mi_lter
miltier93214963miltier
mimeoed1235193mimeoed
mimer94825763mi__mer
mincer104017363mi_ncer
mincier113512473mincier
minded103817833mind_ed
minders103720123mind_ers
mindset10313343mindset
miner76933543mi__ner
mingier103815293mingier
mingler104213843mingler
miniver1238393miniver
minor74920063mi_no_r
minster93914323minster
minter84425103mi_nter
mintier93615993mintier
minuter93510413minuter
mirador1046503mirado_r
mirier83918363mi_rier
mirker123712693mi_rker
mirkier13319053mirkier
mirror848003mirro_r
misadded1335753misadded
misalter1038343misalter
misate81222693misate_
misavers1348063misavers
miscode12310413miscode
miscoded1437983miscoded
miscodes13310423miscodes
miscoin11311433miscoin
miscolor1245603miscolor
miscook1546473miscook
miscopy1636663miscopy
miscue10412223miscue_
miscued1239293miscued
miscues11312393miscues
misdate101413963misdate
misdated121211123misdated
misdates111113633misdates
misdeal1037663misdeal
misdealer1245593misdealer
misdeeds12276813misdeeds
misdeems13255653misdeems
misdial1039643misdial
misdid10510573misd_id
misdoing1238803misdoing
misdoubt1394073misdoubt
misdraw1345623misdraw
misdrove1445433misdrove
mise66043583mis__e_
misenter10310833misenter
miserere1049273miserere
misers85025703mis__ers
misery114113543mis__ery
mises74740563mis__es
misfed124113023mis_fed
misfeed13389683misfeed
misfire12229893misfire
misform1437513misform
misgovern1543063misgovern
misgrew1335523misgrew
mishear1238393mishear
misinfer1345323misinfer
misinter1038833misinter
misjoin1637693misjoin
miskeep1536403miskeep
misknew1633883misknew
mislayer1337503mislayer
misled94719313mis_led
mislie83219153mislie_
mislies92922283mislies
misliker14319573misliker
mismeet113215163mismeet
mismet103722373mis_met
mismove1437083mismove
mismoved1635653mismoved
mismoves1537293mismoves
misnomers1346183misnomers
miso67229903mis_o__
misorder1147283misorder
misos76523293mis_o_s
mispen10312173mis_pen
mispled12310463mispled
misquoter2043383misquoter
misrefer1346103misrefer
missed94423603mis_sed
missel85216523mis_sel
misses85130873mis_ses
misset85028153mis_set
missies93423983missies
missioner1147883missioner
missort9314653missort
missout9412663missout
missteer1037223missteer
misstep11158463misstep
mistaker14109333mistaker
misted93625823mis_ted
misterm114314513mis_term
misters93927513mis_ters
mistook1337153mistook
misuse83213643misuse_
misused104111283misused
misusers10348083misusers
misuses93216023misuses
misword1338413misword
misyoke1635823misyoke
misyoked1834623misyoked
misyokes1735513misyokes
miter75734793mi__ter
miterer92511333miterer
mither114218563mi_ther
mitier83620673mi_tier
mixer145017643mi__xer
moidore1056153moidore
moister94015373mois_ter
molder93819273mold_er
moldier103110033moldier
moodier103212203moodier
mosher114719793mos_her
mosser84618273mos_ser
mossier94413813mossier
mudder104413493m_udder
muddier114110023muddier
muddler113411623muddler
murder93613783murd_er
muser76024123mus__er
musher113820573mus_her
mushier123813593mushier
muskier134312733muskier
mussier93314363mussier
muster84724523mus_ter
mustier94017963mustier
outdoer849273outdoer
piddler112911523piddler
pinder94523453pind_er
pisher114317753pis_her
pisser84416383pis_ser
pissoir945043pissoir
ridder84015143ri_dder
riddler93411263riddler
rider65231303ri_d_er
riser55431053ris__er
risker105414493ris_ker
riskier1138423riskier
shoer84722163__shoer
sidler74716963si_dler
sissier73711363sissier
sister64421583sis_ter
tiddler93110003tiddler
tidier73515113ti_dier
tinder73821803tind_er
undoer73113043_undoer
visiter1038863visiter
visor82512833vis_o_r
widder112913973wi_dder
wider94826353wi_d_er
widower1435343wi_dower
wilder103616473wild_er
winder104025263wind_er
windier113412163windier
wisdom1235983wisdo_m
wisdoms1335453wisdoms
wiser85522803wis__er
wisher123617063wis_her
wispier12249403wispier

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272686.50020619.5
3Display Results2682680.0932881.7
 (SQL Overall)1786912686.99925530.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.