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

243 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
misacts113935(None) 
misact10316691misact_
bisects1137132bisects
didacts1186062didacts
impacts13266502impacts
misacted1338672misacted
misadds1136302misadds
misaims11310112misaims
misate81222692misa_te
miscast11312422miscast
miscasts1238352miscasts
miscuts1139182miscuts
miseats92815782miseats
misfits12279662misfits
mishits122513082mishits
misparts12108172misparts
missets94516572missets
mists76633902mis__ts
muscats1138932muscats
acts66929863___acts
ambsaces1455213ambsaces
amesaces1246693amesaces
basalts9358963basalts
bifaces1448063bifaces
bipacks1745043bipacks
bisect10312873bisect_
bracts105617773_bracts
ciscos104711133cis_cos
cists76624533cis__ts
coacts105314333_coacts
desalts839573desalts
dicasts1078703dicasts
didact10711203didact_
directs102710263directs
disarms1039043disarms
discants112912023discants
discos94915213dis_cos
discs85316263dis_c_s
discus94512113dis_cus
disjects18275923disjects
dismasts1137513dismasts
disparts11109953disparts
dissects11279243dissects
distracts1249283distracts
enacts84012973_enacts
epacts105010393_epacts
exacts15359613_exacts
exsects1655573exsects
facts107021893__facts
fiascos12124743fiascos
fiats85324483fi_a_ts
fiscals1238003fiscals
fiscs105311883fis_c_s
fists85527543fis__ts
giants74713503gi_ants
gists66026193gis__ts
hijacks2333533hijacks
hists86328373his__ts
ikats95311153_ika_ts
impact122310453impact_
imparts11298533imparts
insects93710843insects
islets64513083_islets
kismats13257843kismats
kismets13306883kismets
kists95822113kis__ts
lilacs837483lilac_s
linacs8310813linac_s
lists56628693lis__ts
macacos1338083macacos
maces97139963m__aces
machs125722563m__achs
macks135127603m__acks
macs86742513m__ac_s
maists85817573mais__ts
malts76331753m__alts
manats84623463mana_ts
maracas11313773maracas
marts77442233m__arts
masalas9312053masalas
masas75630413masa__s
mascots113910343mascots
masts77035763m__asts
mats65460293m__a_ts
matts76829183m__atts
mauts75927193m__auts
meats75034053m_ea_ts
menaces112715523menaces
mesas76823203mesa__s
mescals112911563mescals
miaous8511693mi_aous
miaows1145473mi_aows
miasmas1167743miasmas
miasms1097383mi_asms
miauls8178713mi_auls
micas96823053mi__cas
micks135525373mi__cks
mics87435153mi__c_s
midairs1037203midairs
midgets113910253midgets
midguts11296013midguts
midspaces1643993midspaces
midsts95510053mi_dsts
mights123516253mi_ghts
migrants1138183migrants
mikados1444683mikados
miladis1049823miladis
milages103114403milages
millets94216843millets
milts75430713mi__lts
mimics1289363mimic_s
minacity1547373minacity
minarets1048843minarets
minas75434113mina__s
minces104420803mi_nces
mints76834043mi__nts
minuets9259853minuets
miracle1138843miracle
miracles1238333miracles
mirages102213533mirages
misacting1439083misacting
misadapts1442833misadapts
misadd1037163misa_dd
misagents1246793misagents
misaim10311853misa_im
misallots1144533misallots
misally121111063misally
misalter1038343misalter
misalters1136913misalters
misaver1249813misaver
misavers1348063misavers
misbias1139083misbias
miscall1139653miscall
miscalls1239003miscalls
miscite11314383miscite
miscites12313783miscites
miscue10412223mis_cue
miscues11312393miscues
miscut10614823mis_cut
misdate101413963misdate
misdates111113633misdates
misdoes10312493misdoes
miseases102614343miseases
miseat82925713miseat_
misedits1147963misedits
misers85025703mis_ers
mises74740563mis__es
misfaith1644543misfaith
misfaiths1742463misfaiths
misfit112813833misfit_
misfocus1543453misfocus
misgrafts1544293misgrafts
mishaps1438723mishaps
mishit112618203mishit_
miskals13369763miskals
miskicks1544763miskicks
mislays12349243mislays
mislies92922283mislies
mislit83019693mislit_
mismakes16129883mismakes
mismarks1645893mismarks
mismatch1743943mismatch
mismate111415353mismate
mismates121114563mismates
mismeets12297733mismeets
mismet103722373mismet_
misnames12119883misnames
misos76523293mis__os
mispages13311183mispages
mispaints13106183mispaints
mispart111113783mispart_
mispatch1743853mispatch
mispens11311073mispens
misplaces1537953misplaces
misplants1347313misplants
misrate91319143misrate
misrates101318243misrates
miss65339423mis___s
missals93914423missals
missays124010253missays
misseats104011683misseats
missels94614813missels
misses85130873mis_ses
misset85028153misset_
missies93423983missies
missis84417503mis_sis
missorts1038323missorts
missouts1037623missouts
misspaces1546513misspaces
misstarts1145833misstarts
missuits1078023missuits
missus85312293mis_sus
mist66154533mis__t_
mistakes141213413mistakes
misters93927513misters
mistraces13312293mistraces
misty106120453mis__ty
misuses93216023misuses
mitts75523753mi__tts
moats75827643m_oa_ts
mosaics1138073mosaics
mosts76028543mos__ts
mudcats1236223mudcats
mulcts10298713m_ulcts
muscat10314663muscat_
musicks15297053musicks
musics103911783music_s
muskets13258643muskets
muskits13278563muskits
musts75527443mus__ts
mutants938583mutants
mysosts1234543mysosts
outacts9310213outacts
ovisacs1263283ovisac_s
pacts95125803__pacts
piscos105112593pis_cos
pissants1097363pissants
preacts113211363preacts
reacts83616603_reacts
redacts10510943redacts
resects94115593resects
sacks114228873__sacks
sacs65739073__sac_s
salts55431883__salts
scats75930603__scats
sects75622893__sects
sisals63013573sisa_ls
tacts76524123__tacts
tincts84510803ti_ncts
tipcats1137103tipcats
tisanes7311853tisanes
tracts85019073_tracts
trisects1035983trisects
umiacks1534013umi_acks
umiacs1035663umi_ac_s
visages1138693visages
visards11328153visards
visas84317653visa__s
viscus11428503vis_cus
visits9311423vis_its
vivaces1536413vivaces
wisents10249063wisents
wists86728523wis__ts

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.406440125.6
2DLD Change Limit1340272438.87315105.0
3Display Results2432430.0803037.5
 (SQL Overall)1786912439.35919093.0
 
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.