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

251 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
miscites1231378(None) 
miscite11314381miscite_
miscited13310421miscited
ascites9312602_ascites
incites93218482_incites
miscodes13310422miscodes
miscues11312392misc_ues
miscuts1139182miscut_s
misdates111113632misdates
misfiles133110982misfiles
misfires132210582misfires
misfits12279662misfit_s
misgives14329292misgives
mishits122513082mishit_s
mislies92922282misli_es
mislikes143311832mislikes
mislives132912152mislives
mismates121114562mismates
misrates101318242misrates
missies93423982missi_es
missiles103015082missiles
missises103513692missises
missives133212842missives
mistimes12612612mistimes
mistitles1147952mistitles
miswrites1447982miswrites
zincites1946632zincites
abscises1246233abscises
amosites10311233amos_ites
biocides1336933biocides
biotites10310083biotites
biscuits1245133biscuit_s
calcites12313003calcites
ciscoes113610733cisc_oes
cissies94116153cissi_es
cites74435593___cites
dacites101114593_dacites
despites11410313despites
diorites9313523diorites
discases112014503discases
disciples1446403disciples
discuses113112863discuses
dislikes132810843dislikes
disputes1139653disputes
disrates91118153disrates
disunites1088673disunites
excites16310633_excites
fascines13310143fascines
fascitis1346013fascitis
finites10315923fi_nites
hessites1138613hessites
hissies103915823hissi_es
ignites81310583_ignites
illites72415013_illites
incises93414893_incises
incite83618733_incite_
incited103314623_incited
inciter93113773_inciter
inciters103210673_inciters
indites83618983_indites
invites103915813_invites
iolites73819483_iolites
leucites1037333leucites
lignites9129613lignites
limites92915453li_mites
lucites9311863_lucites
mannites10312613mannites
marlites103415263marlites
marmites122212793marmites
mascots113910343mascot_s
mashies12318253mashi_es
masonites1149173masonites
mastitis1039103mastitis
mastixes1738253mastixes
mercies113817563merci_es
mesquites20476433mesquites
miches134320733mi_c_hes
mickles153415003mi_ckles
middies113116153middi_es
midlines112613333midlines
midlives14287463midlives
midwifes17234713midwifes
midwives17274803midwives
migrates111112853migrates
millimes122411373millimes
millines102718063millines
mimetites1346823mimetites
minacities1447993minacities
minces104420803minc__es
mincier113512473minci_er
minciest122913113minci_est
minnies93617363minni_es
minutes93513443mi_nutes
misacted1338673misacted
misacts1139353misact_s
misaimed1338093misaimed
misaims11310113misai_ms
misalter1038343misalter
misalters1136913misalters
misate81222693mis_ate_
misbias1139083misbi_as
misbiases1346253misbiases
misbills1246083misbills
misbinds1345163misbinds
miscalls1239003miscalls
miscasts1238353miscasts
mischief1846423mischief
mischiefs1943063mischiefs
mischoices19124013mischoices
mischose1547263mischose
miscible1447673miscible
misciting1439673misciting
misclass1246843misclass
miscode12310413miscode_
miscoded1437983miscoded
miscoined1448443miscoined
miscoins12311083miscoins
miscooks1645463miscooks
miscopies1549613miscopies
miscreates1448103miscreates
miscue10412223misc_ue_
miscued1239293misc_ued
miscut10614823miscut__
misdate101413963misdate_
misdated121211123misdated
misdials1137493misdials
misdoes10312493mis_does
misdrives1546213misdrives
miseases102614343miseases
miseaten10310773miseaten
miseats92815783miseat_s
misedited1346783misedited
misedits1147963misedit_s
misenter10310833misenter
misenters1139533misenters
miseries10320403miseries
mises74740563mis___es
misfaiths1742463misfaiths
misfile122611553misfile_
misfiled14278653misfiled
misfire12229893misfire_
misfired14238543misfired
misfit112813833misfit__
misfitted1544963misfitted
misgive13339033misgive_
misgiven14245903misgiven
misguides13165333misguides
mishit112618203mishit__
misinter1038833misinter
misinters1138183misinters
miskicks1544763miskicks
mislie83219153misli_e_
mislike132914833mislike_
misliked15319513misliked
misliker14319573misliker
mislikers15317063mislikers
mislit83019693mislit__
mislive122812693mislive_
mislived14328783mislived
mislocates14107223mislocates
mismakes16129883mismakes
mismate111415353mismate_
mismated131111333mismated
mismeets12297733mismeets
mismoves1537293mismoves
misnames12119883misnames
mispages13311183mispages
mispoises1348353mispoises
misprices1547913misprices
misprizes2247223misprizes
misquotes2044593misquotes
misraises1149933misraises
misrate91319143misrate_
misrated111315383misrated
misroutes1148313misroutes
misrules1039383misrules
misses85130873mis__ses
missets94516573misset_s
missile92815403missile_
missions10311903missions
missis84417503missi__s
missive122413143missive_
misstates11710633misstates
misstep11158463mis_step
missteps12156143mis_steps
missuited1257023missuited
missuits1078023missuit_s
missuses10309683missuses
mistakes141213413mistakes
misted93625823mis__ted
mister84728563mis__ter
misters93927513mis__ters
mistier93418713misti_er
mistiest103018313misti_est
mistime11312613mistime_
mistimed1339123mistimed
mistiness111911633mistiness
mistitle1038523mistitle
mistitled1246283mistitled
mists76633903mis__t_s
mistunes10311133mistunes
mistypes15116713mistypes
misuses93216023mis_uses
miswrite1348923miswrite_
misyokes1735513misyokes
mites75141803m___ites
miticides1447083miticides
mitises9315543mi_tises
mullites10411643mullites
muscatel1246063muscatel
muscatels1343443muscatels
muscats1138933muscat_s
muscids12187973musci_ds
muscles11310563musc_les
muscovites1752693muscovites
musettes1037433musettes
muskies133614673muski_es
muskits13278563muskit_s
muspikes1635243muspikes
niobites1037313niobites
nitrites82313453nitrites
oscines9310363_oscines
picrites121811083picrites
pinites9319533pi_nites
piscinas1275483piscinas
piscine11610973piscine_
pismires1235883pismires
pisolites1149383pisolites
pistes85325633pis__tes
pumicites1545623pumi_cites
recites93524583_recites
reincites1148493reincites
resites74027793res_ites
respites10513243respites
scutes85219193__scutes
sienites8311913sienites
sissies73716603sissi_es
sites56045433__s_ites
skites104418043__skites
smites83921923__smites
spites84127333__spites
suites63727403__suites
tillites8312833tillites
viscoses1338343viscoses
visited1168773vis_ited
visiter1038863vis_iter
visiters1137413vis_iters
visits9311423vis_it_s
zincates1937743zincates
zincite1837233zincite_
zoisites1744973zois_ites

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 Filter1786911461620.440406115.9
2DLD Change Limit1461622517.32619951.1
3Display Results2512510.1102281.8
 (SQL Overall)1786912517.87622688.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.