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

219 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
mislives13291215(None) 
midlives14287461midlives
misgives14329291misgives
mislies92922281misli_es
mislikes143311831mislikes
mislive122812691mislive_
mislived14328781mislived
missives133212841missives
dislikes132810842dislikes
midlines112613332midlines
midwives17274802midwives
millimes122411372millimes
millines102718062millines
miscites12313782miscites
misdrives1546212misdrives
misfiles133110982misfiles
misfires132210582misfires
misgive13339032misgive_
misgiven14245902misgiven
mislie83219152misli_e_
mislike132914832mislike_
misliked15319512misliked
misliker14319572misliker
mislikers15317062mislikers
mismoves1537292mismoves
missies93423982missi_es
missiles103015082missiles
missises103513692missises
missive122413142missive_
mistimes12612612mistimes
airlines8312793airlines
aisles64721143aisl__es
beslimes1246953beslimes
bialies93618413biali_es
billies93923503billi_es
cilices113814023ci_lices
cissies94116153cissi_es
dillies84122163dilli_es
dislike122913453dislike_
disliked14288553disliked
disliker13358643disliker
dislikers14286423dislikers
dislimns1144813dislimns
dissaves1239413dissaves
distaves12311403distaves
emissive1345923emissive_
enslaves1136393enslaves
fillies103420253filli_es
fishlines15246843fishlines
fishwives2142173fishwives
gillies84120963gilli_es
girlies83013703girli_es
hiplines13310593hiplines
hissies103915823hissi_es
huswives1742933huswives
illites72415013_illites
implies11312123impli_es
iolites73819483_iolites
isles54220563_isl__es
isolines8312303_isolines
jussives1833843jussives
killies113318113killi_es
lilies63021413li_li_es
lisles63416283lisl__es
lives86133193___lives
lowlives1434573lowlives
mainlines1138513mainlines
malices114316623m_alices
malines93625603m_alines
marlines103818713marlines
marlites103415263marlites
mashies12318253mashi_es
massive12289773massive_
mastixes1738253mastixes
mealies92821933meali_es
middies113116153middi_es
midlife13248303midlife_
midlifer14215793midlifer
midlifers15254933midlifers
midline102315103midline_
midlists1137523midlists
midwifes17234713midwifes
midwived18263553midwived
milages103114403mi_lages
miles74645073mi_l__es
milieu8314113mi_li_eu
milieus939803mi_lieus
millages113212903millages
milles84526563mi_l_les
milliares1149403milliares
milliemes13255843milliemes
millier93716703milli_er
milliers102611903milliers
millime112511403millime_
milline92519113milline_
milliner102811863milliner
milliners11289953milliners
millings113712583millings
millions101712433millions
milliped1337383milliped
millipeds1444703millipeds
millirem1245693millirem
millirems1344323millirems
miniver1238393mi_niver
minivers1337483mi_nivers
minnies93617363minni_es
misaimed1338093misaimed
misaims11310113misai_ms
misaligns1244773misaligns
misallies1148383misallies
misaver1249813mis_aver
misavers1348063mis_avers
misbelieves18123103misbelieves
misbias1139083misbi_as
misbiases1346253misbiases
misbills1246083misbills
misbinds1345163misbinds
miscite11314383miscite_
miscited13310423miscited
miscodes13310423miscodes
miscues11312393mis_cues
misdates111113633misdates
misdials1137493misdials
misdivides17113303misdivides
misdoes10312493mis_does
misdrive1446683misdrive_
misdriven1544073misdriven
miseases102614343miseases
miseries10320403miseries
mises74740563mis___es
misfile122611553misfile_
misfiled14278653misfiled
misfire12229893misfire_
misfired14238543misfired
misfits12279663misfi_ts
misgave13298283misgave_
misguides13165333misguides
mishits122513083mishi_ts
miskicks1544763miskicks
mislabel1296173mislabel
mislabels13114313mislabels
mislayer1337503mislayer
mislayers1445943mislayers
mislays12349243misl_ays
misleads11358543misleads
misled94719313misl__ed
mislight1447243mislight
mislights1544663mislights
mislit83019693misli__t
misliving1546983misliving
mislodges1344363mislodges
mismakes16129883mismakes
mismates121114563mismates
mismove1437083mismove_
mismoved1635653mismoved
misnames12119883misnames
mispages13311183mispages
misplaces1537953misplaces
mispoises1348353mispoises
misprices1547913misprices
misprizes2247223misprizes
misraises1149933misraises
misrates101318243misrates
misrelies1149723misreli_es
misrules1039383misrules
misses85130873mis__ses
missile92815403missile_
missions10311903missions
missis84417503missi__s
missuses10309683missuses
mistakes141213413mistakes
mistier93418713misti_er
mistiest103018313misti_est
mistime11312613mistime_
mistimed1339123mistimed
mistiness111911633mistiness
mistitles1147953mistitles
mistunes10311133mistunes
mistypes15116713mistypes
misuses93216023mis_uses
miswrites1447983miswrites
misyokes1735513misyokes
mitises9315543mi_tises
molies84429513m_oli_es
mollies93420233molli_es
motives123611893m_otives
mudslides1343233mudslides
muhlies1238933muhli_es
mullites10411643mullites
muskies133614673muski_es
muslins9312213musli_ns
muspikes1635243muspikes
myelines1337123myelines
nonlives1138363nonlives
olives94313953__olives
omissive1345103omissive_
outlives112511763outlives
passives13228823passives
pismires1235883pismires
pisolites1149383pisolites
prelives13310383prelives
relives104619443_relives
shives124921413__shives
sillies73425083silli_es
sissies73716603sissi_es
skives134113943__skives
slaves95023023__slaves
slices84022853__slices
slides73922183__slides
slieves10378963__slieves
slimes84722043__slimes
slipes84921413__slipes
sliver94116593__sliver
slivers104115253__slivers
swives123915183__swives
tillites8312833tillites
unlives102010953_unlives
visive1257873vis_ive_
willies103920153willi_es

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.420425454.8
2DLD Change Limit1461622197.28320068.9
3Display Results2192190.0932354.8
 (SQL Overall)1786912197.79622920.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.