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

263 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
mistimes1261261(None) 
mistime11312611mistime_
mistimed1339121mistimed
airtimes1037502airtimes
distomes11314162distomes
mastixes1738252mastixes
millimes122411372millimes
misaimed1338092misaimed
misaims11310112misaim_s
miscites12313782miscites
misfiles133110982misfiles
misfires132210582misfires
misgives14329292misgives
mislies92922282misli_es
mislikes143311832mislikes
mislives132912152mislives
misnames12119882misnames
missies93423982missi_es
missiles103015082missiles
missises103513692missises
missives133212842missives
mistakes141213412mistakes
mistier93418712misti_er
mistiest103018312misti_est
mistiness111911632mistiness
mistitles1147952mistitles
mistunes10311132mistunes
mistypes15116712mistypes
mitises9315542mi_tises
mittimus1243022mittimus
pastimes123611902pastimes
stimes85920572__stimes
airtime948063airtime_
amities9317383ami_ti_es
armistices1443673armistices
bastiles10313353bastiles
bedtimes1336593bedtimes
beslimes1246953beslimes
betimes115114413_betimes
bhisties1339003bhisti_es
bigtime1235753bigtime_
biotites10310083biotites
bistres94017213bist_res
centimes124012613centimes
cissies94116153cissi_es
cistuses1038283cistuses
cities84524853ci_ti_es
costumes1258013costumes
cystines1339473cystines
daytimes1434483daytimes
destines93619663destines
dirties83119383dirti_es
dislikes132810843dislikes
dislimns1144813dislimns
dismes95617673dis__mes
distaves12311403distaves
distichs1447633distichs
distills9319043distills
distils83015803disti_ls
distome10313233distome_
ditties83116983ditti_es
epistomes1346013epistomes
fifties132111083fifti_es
gisarmes1144433gisarmes
hissies103915823hissi_es
histones11312803histones
hostiles11312213hostiles
intimas9119583_intimas
intime81014273_intime_
intines7921113_intines
isatines8310663_isatines
isthmus1243263_isthmus
istles62814983_ist_les
justices1737523justices
kilties113014143kilti_es
kitties113213623kitti_es
lifetimes1444153lifetimes
listees73416673list_ees
listings93310043listings
mantises10317923mantises
mashies12318253mashi_es
mastiches1647333mastiches
mastics112614783masti_cs
mastiffs1644233mastiffs
mastitis1039103mastitis
mealtimes1345243mealtimes
meantimes1345883meantimes
mesdames1346043mesdames
mestees94617753mest_ees
mestinoes1157313mestinoes
mestinos1048163mestinos
mestizas1944703mestizas
mestizoes2064173mestizoes
mestizos1944493mestizos
middies113116153middi_es
midlines112613333midlines
midlives14287463midlives
midwifes17234713midwifes
midwives17274803midwives
milliemes13255843milliemes
millime112511403millime_
millines102718063millines
miltier93214963milti_er
miltiest103015173milti_est
mimes95732023m___imes
mimetites1346823mimetites
minims104514813mi_nim_s
minnies93617363minni_es
mintages111110513mintages
mintier93615993minti_er
mintiest103217143minti_est
miotics112710653mioti_cs
misaim10311853misaim__
misatones1148933misatones
misbias1139083misbi_as
misbiases1346253misbiases
misbills1246083misbills
misbinds1345163misbinds
miscite11314383miscite_
miscited13310423miscited
miscodes13310423miscodes
miscues11312393mis_cues
misdates111113633misdates
misdeems13255653misdeems
misdials1137493misdials
misdoes10312493mis_does
misdrives1546213misdrives
miseases102614343miseases
miseries10320403miseries
mises74740563mis___es
misfile122611553misfile_
misfiled14278653misfiled
misfire12229893misfire_
misfired14238543misfired
misfits12279663misfi_ts
misframes1646633misframes
misgive13339033misgive_
misgiven14245903misgiven
misguides13165333misguides
mishits122513083mishi_ts
miskicks1544763miskicks
mislie83219153misli_e_
mislike132914833mislike_
misliked15319513misliked
misliker14319573misliker
mislikers15317063mislikers
mislive122812693mislive_
mislived14328783mislived
mismakes16129883mismakes
mismates121114563mismates
mismet103722373mis__met
mismoves1537293mismoves
misname11119483misname_
misnamed13127593misnamed
misnomer1247143misnomer
misnomers1346183misnomers
mispages13311183mispages
mispoises1348353mispoises
misprices1547913misprices
misprizes2247223misprizes
misraises1149933misraises
misrates101318243misrates
misrules1039383misrules
misses85130873mis__ses
missile92815403missile_
missions10311903missions
missis84417503missi__s
missive122413143missive_
misstamps1543373misstamps
misstates11710633misstates
misstrikes1644363misstrikes
misstyles1445023misstyles
missuses10309683missuses
mistake131312623mistake_
mistaken14147833mistaken
mistaker14109333mistaker
mistakers15117083mistakers
mistbows1543993mistbows
misted93625823mist__ed
mistends11419593mistends
mister84728563mist__er
mistermed1438363mistermed
misterms123711353misterms
misters93927513mist_ers
misthinks1843353misthinks
misthrew16124763misthrew
mistily122612343misti_ly
mistiming1438913mistiming
misting103623383misti_ng
mistitle1038523mistitle
mistitled1246283mistitled
mistraces13312293mistraces
mistrals101212623mistrals
mistress10310703mistress
mistrials1148133mistrials
mists76633903mist___s
mistune9310653mistune_
mistuned1157723mistuned
mistype14126523mistype_
mistyped1685173mistyped
misuses93216023mis_uses
miswrites1447983miswrites
misyokes1735513misyokes
mites75141803mi_t__es
mitier83620673mi_ti_er
mitiest93520053mi_ti_est
mitis75425993mi_ti__s
mitoses9312183mi_toses
mitres83922073mi_t_res
mittimuses1452463mittimuses
mixtures1735753mixtures
moieties10311263moieti_es
moistures1147323moistures
mortices12711563mortices
mortises10713613mortises
motiles93317433m_otiles
motives123611893m_otives
muskies133614673muski_es
muspikes1635243muspikes
mustees94614923must_ees
mustier94017963musti_er
mustiest103017533musti_est
mustiness112211663mustiness
mutines93117823m_utines
myotomes1546233myotomes
mystics14279103mysti_cs
mystifies1745883mystifies
mystiques2342423mystiques
nasties73520493nasti_es
nifties102612503nifti_es
ofttimes1343123ofttimes
optimes1148473_optimes
pasties94529813pasti_es
pastime114611973pastime_
pastises103616053pastises
pieties9419223pieti_es
pigsties1139783pigsti_es
pismires1235883pismires
pistes85325633pist__es
pistils93314303pisti_ls
pistoles102514723pistoles
pities83828083pi_ti_es
posties93128813posti_es
ragtimes1135823ragtimes
retimes95020173_retimes
riptides1136413riptides
septimes1238303septimes
sestines82717243sestines
sissies73716603sissi_es
sixties14310973sixti_es
slimes84722043__slimes
sties55132983__sti_es
stiles64328773__stiles
stime76521803__stime_
stimies9316563__stimies
stipes84524053__stipes
teatimes1039443teatimes
times75630823___times
titties73617363titti_es
uptimes1177553_uptimes
vestiges1238243vestiges
victims1436003victim_s
wartimes1336963wartimes

Search took 9 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 Limit1461622637.89018525.0
3Display Results2632630.1102390.9
 (SQL Overall)1786912638.44021171.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.