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

164 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
mislived1432878(None) 
misliked15319511misliked
mislive122812691mislive_
mislives132912151mislives
disliked14288542disliked
midlives14287462midlives
midwived18263552midwived
milliped1337382milliped
misaimed1338092misaimed
miscited13310422miscited
misfiled14278652misfiled
misfired14238542misfired
misgive13339032misgive_
misgiven14245902misgiven
misgives14329292misgives
misled94719312misl__ed
mislie83219152misli_e_
mislies92922282misli_es
mislike132914832mislike_
misliker14319572misliker
mislikes143311832mislikes
mismoved1635652mismoved
missive122413142missive_
missives133212842missives
mistimed1339122mistimed
aisled74516183aisl__ed
beslaved1435023beslaved
beslimed1335013beslimed
dislike122913453dislike_
disliker13358643disliker
dislikes132810843dislikes
dislimned1344623dislimned
dissaved1337313dissaved
emissive1345923emissive_
enslaved1245063enslaved
filliped1435223filliped
fissiped1444153fissiped
gillied95512313gilli_ed
implied1238613impli_ed
isled64615993_isl__ed
isleted837523_isleted
lilied73913213li_li_ed
lived95523723___lived
mainlined1254353mainlined
massive12289773massive_
midlife13248303midlife_
midlifer14215793midlifer
midline102315103midline_
midlines112613333midlines
midsized2144733midsized
midwifed18233933midwifed
midwives17274803midwives
milded104416153mi_l_ded
milieu8314103mi_li_eu
milked134612573mi_l_ked
milled94326173mi_l_led
milleped1335173milleped
milliard1147033milliard
millier93716703milli_er
millime112511403millime_
millimes122411373millimes
milline92519113milline_
milliner102811863milliner
millines102718063millines
millipede1444223millipede
millipeds1444703millipeds
millirem1245693millirem
milted93919943mi_l_ted
miniver1238393mi_niver
misacted1338673misacted
misadded1335753misadded
misaligned1443583misaligned
misallied1246533misallied
misaver1249813mis_aver
misbelieved19152733misbelieved
misbiased1444843misbiased
misbilled1445173misbilled
misbind1258263misbi_nd
miscite11314383miscite_
miscites12313783miscites
misclaimed1744263misclaimed
miscoded1437983miscoded
miscoined1448443miscoined
miscued1239293mis_cued
misdated121211113misdated
misdeed113211053mis_deed
misdialed1345503misdialed
misdid10510563misdi__d
misdivide16103793misdivide
misdivided18102933misdivided
misdrive1446683misdrive_
misdriven1544073misdriven
misdrives1546213misdrives
misedited1346783misedited
misfed124113023mis__fed
misfeed13389683mis_feed
misfield14265913misfield
misfile122611553misfile_
misfiles133110983misfiles
misfire12229893misfire_
misfires132210583misfires
misfitted1544953misfitted
misgave13298283misgave_
misguided14144643misguided
misjoined1945453misjoined
miskicked1744063miskicked
mislabel1296163mislabel
mislaid1039293misl_aid
mislayer1337503mislayer
mislead10419973misl_ead
misleared1277453misleared
mislight1447243mislight
mislighted1743653mislighted
mislikers15317053mislikers
mislit83019693misli__t
misliving1546983misliving
mislodged1443843mislodged
mismated131111333mismated
mismove1437083mismove_
mismoves1537293mismoves
misnamed13127593misnamed
mispaged1438243mispaged
misplaced1646253misplaced
misplayed1745303misplayed
mispled12310463mis_pled
mispoised1446793mispoised
mispriced1646423mispriced
misprized2346603misprized
misraised1268303misraised
misrated111315383misrated
misrelied1247243misreli_ed
misruled1137083misruled
missed94423603mis__sed
missies93423983missi_es
missile92815403missile_
missiles103015083missiles
missioned1248603missioned
missises103513693missises
missuited1257003missuited
misted93625823mis__ted
mistier93418713misti_er
mistime11312613mistime_
mistimes12612613mistimes
mistitled1246273mistitled
mistuned1157723mistuned
mistyped1685173mistyped
misused104111273mis_used
misyoked1834623misyoked
motived13357763m_otived
omissive1345103omissive_
outlived12269583outlived
relived115114683_relived
skived14429893__skived
slaved104017043__slaved
sliced94416313__sliced
slimed94915123__slimed
sliped95417063__sliped
sliver94116593__sliver
swived133610633__swived
unlived112511373_unlived
unsliced1138083unsliced
visited1168773vis_ited
visive1257873vis_ive_
willied114611563willi_ed

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621648.75016704.2
3Display Results1641640.0802050.0
 (SQL Overall)1786911649.00319847.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.