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

236 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
mislive12281269(None) 
misgive13339031misgive
mislie83219151misli_e
mislike132914831mislike
mislived14328781mislived
mislives132912151mislives
missive122413141missive
dislike122913452dislike
emissive1345922emissive
massive12289772massive
midlife13248302midlife
midline102315102midline
midlives14287462midlives
millime112511402millime
milline92519112milline
miscite11314382miscite
misdrive1446682misdrive
misfile122611552misfile
misfire12229892misfire
misgave13298282misgave
misgiven14245902misgiven
misgives14329292misgives
mislies92922282mislies
misliked15319512misliked
misliker14319572misliker
mislikes143311832mislikes
mislit83019692misli_t
mismove1437082mismove
missile92815402missile
missives133212842missives
mistime11312612mistime
omissive1345102omissive
visive1257872vis_ive
admissive1543023admissive
airlike11310333airlike
airline7315033airline
aisle55223193aisl__e
alive85722513__alive
amusive1246253amus_ive
asslike1137373asslike
belive115415303_belive
beslime1146833beslime
biblike1536893biblike
billie85019173billi_e
cilice103213353ci_lice
costive12312843costive
disclike15208653disclike
dishlike16287893dishlike
disklike12206743disklike
disliked14288553disliked
disliker13358643disliker
dislikes132810843dislikes
dislimn1056103dislimn
dissave1139413dissave
emulsive1344533emulsive
enslave1036273enslave
festive1339773festive
fictive1537023fictive
finlike14279063finlike
fishlike18225873fishlike
fishline14237583fishline
fissile10269653fissile
gillie74816943gilli_e
girlie73711463girli_e
hiplike1637603hiplike
hipline12311423hipline
illite63414923_illite
iolite63221983_iolite
isle45121703_isl__e
isling71213883_isling
isoline7314013_isoline
jiglike19105333jiglike
jussive1734293jussive
kidlike1137063kidlike
killie104114893killi_e
liplike1337283liplike
lisle53916723lisl__e
live76540993___live
mainline1039863mainline
malice104818483m_alice
maline84529083m_aline
manlike133012783manlike
maplike15299273maplike
marline93320953marline
marlite92917073marlite
mashie11315933mashi_e
masklike1335593masklike
mastlike1437863mastlike
mealie82519813meali_e
midlifer14215793midlifer
midlines112613333midlines
midlist10312513midlist
midsize1946393midsize
midwife16225523midwife
midwived18263553midwived
midwives17274803midwives
milage93414123mi_lage
mile66352573mi_l__e
milia72719573mi_li_a
milieu8314113mi_lieu
milium104712683mi_lium
millage103112753millage
mille75029133mi_l_le
milliare1039153milliare
millieme12276803millieme
millier93716703millier
millimes122411373millimes
milliner102811863milliner
millines102718063millines
milling103223683milling
million91813143million
milliped1337383milliped
millirem1245693millirem
miniver1238393mi_niver
misaim10311853misai_m
misaimed1338093misaimed
misaims11310113misaims
misalign1146433misalign
misate81222693mis_ate
misaver1249813mis_aver
misbelieve17123263misbelieve
misbias1139083misbias
misbill1137033misbill
misbind1258273misbind
miscible1447673miscible
miscited13310423miscited
miscites12313783miscites
miscode12310413miscode
miscue10412223mis_cue
misdate101413963misdate
misdial1039643misdial
misdid10510573misdi_d
misdivide16103793misdivide
misdone10310863misdone
misdriven1544073misdriven
misdrives1546213misdrives
misdrove1445433misdrove
mise66043583mis___e
misease92713043misease
misfiled14278653misfiled
misfiles133110983misfiles
misfired14238543misfired
misfires132210583misfires
misfit112813833misfi_t
misfits12279663misfits
misguide12145703misguide
mishit112618203mishi_t
mishits122513083mishits
miskick1435613miskick
mislabel1296173mislabel
mislaid1039303mislaid
mislain9311243mislain
mislay113510683misl_ay
mislayer1337503mislayer
mislays12349243mislays
mislead10419973mislead
misled94719313misl_ed
mislight1447243mislight
mislikers15317063mislikers
misliving1546983misliving
mislodge1244113mislodge
mislying1437843mislying
mismade12129353mismade
mismake15139373mismake
mismate111415353mismate
mismoved1635653mismoved
mismoves1537293mismoves
misname11119483misname
mispage12310523mispage
misplace1437553misplace
mispoise1248263mispoise
misprice1448133misprice
misprize2147543misprize
misraise10410523misraise
misrate91319143misrate
misrule939353misrule
missies93423983missies
missiles103015083missiles
missing103619073missing
mission9312743mission
missis84417503missi_s
missises103513693missises
mistake131312623mistake
mistier93418713mistier
mistily122612343mistily
mistimed1339123mistimed
mistimes12612613mistimes
misting103623383misting
mistitle1038523mistitle
mistune9310653mistune
mistype14126523mistype
misuse83213643mis_use
miswrite1348923miswrite
misyoke1635823misyoke
moline84422033m_oline
mollie83517103molli_e
mosslike1435453mosslike
motive113112143m_otive
mudslide1243593mudslide
mullite9313013mullite
muskie123412543muski_e
muslin8312213musli_n
muslins9312213muslins
muspike1536043muspike
myeline1238253myeline
niblike1336703niblike
olive84817153__olive
outlive102513033outlive
passive12239593passive
piglike14157313piglike
piscine11610973piscine
pismire1135353pismire
pisolite10310373pisolite
puslike1347563puslike
relive95120783_relive
remissive1445773remissive
restive10315933restive
riblike1337333riblike
shive114423423__shive
skive124614113__skive
slave84224033__slave
slice74925823__slice
slide64725413__slide
slieve9359273__slieve
slime74925753__slime
slipe75626133__slipe
sliver94116593__sliver
swive115316193__swive
tillite7313563tillite
tinlike11248803tinlike
tussive1035303tussive
unlive92712333_unlive
viselike1536923viselike
wiglike15125853wiglike
willie94116453willi_e
wisplike1734713wisplike

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 Filter1786911340270.440406115.9
2DLD Change Limit1340272366.53020524.8
3Display Results2362360.0802950.0
 (SQL Overall)1786912367.05025346.2
 
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.