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

273 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
mistime1131261(None) 
mistimed1339121mistimed
mistimes12612611mistimes
airtime948062airtime
bigtime1235752bigtime
distome10313232distome
intime81014272_intime
millime112511402millime
misaim10311852misaim_
misaimed1338092misaimed
misaims11310112misaims
miscite11314382miscite
misfile122611552misfile
misfire12229892misfire
misgive13339032misgive
mislie83219152misli_e
mislike132914832mislike
mislive122812692mislive
misname11119482misname
missile92815402missile
missive122413142missive
mistake131312622mistake
mistier93418712mistier
mistily122612342mistily
misting103623382misting
mistitle1038522mistitle
mistune9310652mistune
mistype14126522mistype
pastime114611972pastime
stime76521802__stime
airtimes1037503airtimes
anytime1246043anytime
armistice1345033armistice
bastile9313913bastile
bedtime1236973bedtime
beslime1146833beslime
betime105914833_betime
bhistie1236773bhisti_e
biotite9311033biotite
bistate9313823bistate
bistre83815023bist_re
centime114513033centime
costive12312843costive
costume1157853costume
cystine1239333cystine
daytime1344783daytime
destine83719953destine
dislike122913453dislike
dislimn1056103dislimn
disme85716243dis__me
distich13312173distich
distil73616433disti_l
distill83011323distill
distils83015803distils
distomes11314163distomes
emissive1345923emissive
epistome1246263epistome
festive1339773festive
fictile1238023fictile
fictive1537023fictive
fissile10269653fissile
fistic11812573fisti_c
fisting113818123fisting
gisarme1044173gisarme
histing113720373histing
histone10312843histone
hostile10312553hostile
intima81910033_intima
intimae9109753_intimae
intine61021983_intine
isatine7311763_isatine
isthmi1143603_isthmi
istle52214713_ist_le
justice1637423justice
kiltie103210963kilti_e
lifetime1343983lifetime
lissome937583lissome
listee64223063list_ee
listing84020593listing
maritime1247383maritime
mashie11315933mashi_e
massive12289773massive
mastic103119173masti_c
mastiche1547173mastiche
mastics112614783mastics
mastiff1538163mastiff
masting104325823masting
mastix152310513masti_x
mastixes1738253mastixes
mastlike1437863mastlike
mealtime1245123mealtime
meantime1245983meantime
mestee84523883mest_ee
mestino9411643mestino
mestiza1835383mestiza
mestizo1845943mestizo
midlife13248303midlife
midline102315103midline
midsize1946393midsize
midwife16225523midwife
millieme12276803millieme
millimes122411373millimes
milline92519113milline
miltier93214963miltier
milting103619123milting
mime85736403m___ime
mimetite1247603mimetite
minim97321603mi_nim_
minima105512653mi_nima
minims104514813mi_nims
mintage101110123mintage
mintier93615993mintier
minting103020813minting
minutiae1045593minutiae
miotic103715753mioti_c
miotics112710653miotics
misate81222693mis_ate
misatone1049763misatone
misbias1139083misbias
misbill1137033misbill
misbind1258273misbind
miscible1447673miscible
miscited13310423miscited
miscites12313783miscites
miscode12310413miscode
miscue10412223mis_cue
misdate101413963misdate
misdeem12217873misdeem
misdial1039643misdial
misdid10510573misdi_d
misdone10310863misdone
misdrive1446683misdrive
mise66043583mis___e
misease92713043misease
misfiled14278653misfiled
misfiles133110983misfiles
misfired14238543misfired
misfires132210583misfires
misfit112813833misfi_t
misfits12279663misfits
misframe1546973misframe
misgave13298283misgave
misgiven14245903misgiven
misgives14329293misgives
misguide12145703misguide
mishit112618193mishi_t
mishits122513083mishits
miskick1435613miskick
mislies92922283mislies
misliked15319513misliked
misliker14319573misliker
mislikes143311833mislikes
mislit83019693misli_t
mislived14328783mislived
mislives132912153mislives
mismade12129353mismade
mismake15139373mismake
mismate111415353mismate
mismet103722373mis__met
mismove1437083mismove
misnamed13127593misnamed
misnames12119883misnames
misnomer1247143misnomer
mispage12310523mispage
mispoise1248263mispoise
misprice1448133misprice
misprize2147543misprize
misraise10410523misraise
misrate91319143misrate
misrule939353misrule
missies93423983missies
missiles103015083missiles
missing103619073missing
mission9312743mission
missis84417503missi_s
missises103513693missises
missives133212843missives
misstamp1443803misstamp
misstate10711343misstate
misstrike1544893misstrike
misstyle1345273misstyle
mist66154533mist___
mistaken14147833mistaken
mistaker14109333mistaker
mistakes141213413mistakes
mistbow1443993mistbow
misted93625823mist_ed
mistend103812523mistend
mister84728563mist_er
misterm114314513misterm
mistermed1438363mistermed
misterms123711353misterms
misters93927513misters
misteuk1335893misteuk
misthink1745433misthink
misthrew16124763misthrew
mistiest103018313mistiest
mistiming1438913mistiming
mistiness111911633mistiness
mistitled1246283mistitled
mistitles1147953mistitles
mistook1337153mistook
mistrace12312643mistrace
mistral91013643mistral
mistrial10311383mistrial
mists76633903mist__s
mistuned1157723mistuned
mistunes10311133mistunes
misty106120453mist__y
mistyped1685173mistyped
mistypes15116713mistypes
misuse83213643mis_use
miswrite1348923miswrite
misyoke1635823misyoke
mite66249413mi_t__e
mitier83620673mi_tier
mitis75425993mi_ti_s
mitises9315543mi_tises
mitre75522423mi_t_re
mittimus1243023mittimus
mixture1635413mixture
moisture1046653moisture
mortice11711493mortice
mortise9713533mortise
moste75925083most__e
motile83818343m_otile
motive113112143m_otive
muskie123412543muski_e
muspike1536043muspike
mustee83922103must_ee
mustier94017963mustier
mustily123613633mustily
musting103221073musting
mutine84420373m_utine
myotome1445483myotome
mystic132711643mysti_c
mystics14279103mystics
mystify1843563mystify
mystique2242393mystique
omissive1345103omissive
onetime937623onetime
optime1079353_optime
pastie85525523pasti_e
pastimes123611903pastimes
piscine11610973piscine
pismire1135353pismire
piste75824603pist__e
pistil83915073pisti_l
pistils93314303pistils
pistole92414313pistole
postie84123963posti_e
pristine10313503pristine
ragtime1036163ragtime
restive10315933restive
retime85321803_retime
riptide1036883riptide
septime1138803septime
sestine73017923sestine
slime74925753__slime
stile54931573__stile
stimes85920573__stimes
stimy105114743__stimy
stipe76523373__stipe
teatime9310083teatime
time66235013___time
tittie63213153titti_e
uptime1067673_uptime
vestige1137433vestige
victim1337693victim_
victims1436003victims
visive1257873vis_ive
wartime1237743wartime
wisting113519743wisting

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.436409841.7
2DLD Change Limit1340272736.42320866.7
3Display Results2732730.1102481.8
 (SQL Overall)1786912736.96925640.8
 
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.