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

194 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
misliked1531951(None) 
disliked14288551disliked
mislike132914831mislike_
misliker14319571misliker
mislikes143311831mislikes
mislived14328781mislived
dislike122913452dislike_
disliker13358642disliker
dislikes132810842dislikes
milked134612572mi_l_ked
milliped1337382milliped
misaimed1338092misaimed
miscited13310422miscited
misfiled14278652misfiled
misfired14238542misfired
miskicked1744062miskicked
misled94719312misl__ed
mislie83219152misli_e_
mislies92922282misli_es
mislikers15317052mislikers
mislive122812692mislive_
mislives132912152mislives
mistimed1339122mistimed
misyoked1834622misyoked
airlike11310333airlike_
aisled74516183aisl__ed
asslike1137373asslike_
beslimed1335013beslimed
biblike1536893biblike_
bilked134012943bi_l_ked
disclike15208653disclike_
dishlike16287893dishlike_
disked125015763dis__ked
disklike12206743disklike_
dislikers14286423dislikers
dislimned1344623dislimned
disyoked1745463disyoked
filliped1435223filliped
finlike14279063finlike_
fishlike18225873fishlike_
fissiped1444153fissiped
gillied95512313gilli_ed
hiplike1637603hiplike_
implied1238623impli_ed
isled64615993_isl__ed
isleted837523_isleted
jiglike19105333jiglike_
kidlike1137063kidlike_
liked104523813___liked
lilied73913213li_li_ed
liplike1337283liplike_
mainlined1254353mainlined
manlike133012783manlike_
maplike15299273maplike_
masked134316523mas__ked
masklike1335593masklike_
mastlike1437863mastlike_
midlife13248303midlife_
midlifer14215793midlifer
midline102315103midline_
midlines112613333midlines
midlives14287463midlives
midsized2144733midsized
midwifed18233933midwifed
midwived18263553midwived
miked125020453m___iked
milded104416153mi_l_ded
milieu8314113mi_li_eu
milker124814323mi_l_ker
milkier133411163mi_lkier
milled94326173mi_l_led
milleped1335173milleped
milliard1147033milliard
millier93716703milli_er
millime112511403millime_
millimes122411373millimes
milline92519113milline_
milliner102811863milliner
millines102718063millines
millipede1444223millipede
millipeds1444703millipeds
millirem1245693millirem
milted93919943mi_l_ted
mimicked1943253mimicked
misacted1338673misacted
misadded1335753misadded
misaligned1443583misaligned
misallied1246533misallied
misbiased1444843misbiased
misbilled1445173misbilled
misbind1258273misbi_nd
miscite11314383miscite_
miscites12313783miscites
misclaimed1744263misclaimed
miscoded1437983miscoded
miscoined1448443miscoined
miscooked1844693miscooked
miscued1239293mis_cued
misdated121211113misdated
misdeed113211053mis_deed
misdialed1345503misdialed
misdid10510563misdi__d
misedited1346783misedited
misfed124113023mis__fed
misfeed13389683mis_feed
misfield14265913misfield
misfile122611553misfile_
misfiles133110983misfiles
misfire12229893misfire_
misfires132210583misfires
misfitted1544953misfitted
misgive13339033misgive_
misgiven14245903misgiven
misgives14329293misgives
misguided14144653misguided
misjoined1945453misjoined
mislabel1296163mislabel
mislaid1039293misl_aid
mislayer1337503mislayer
mislead10419973misl_ead
misleared1277453misleared
mislight1447243mislight
mislighted1743653mislighted
misliking1637113misliking
mislit83019693misli__t
mislodged1443843mislodged
mismake15139373mismake_
mismakes16129883mismakes
mismarked1845243mismarked
mismated131111333mismated
mismoved1635653mismoved
misnamed13127593misnamed
mispaged1438243mispaged
mispickel1942973mispickel
misplaced1646253misplaced
misplayed1745303misplayed
mispled12310463mis_pled
mispoised1446803mispoised
mispriced1646423mispriced
misprized2346603misprized
misraised1268313misraised
misrated111315383misrated
misrelied1247243misreli_ed
misruled1137083misruled
missed94423603mis__sed
missies93423983missi_es
missile92815403missile_
missiles103015083missiles
missioned1248603missioned
missises103513693missises
missive122413143missive_
missives133212843missives
missuited1257013missuited
mistake131312613mistake_
mistaken14147823mistaken
mistaker14109323mistaker
mistakes141213403mistakes
misted93625823mis__ted
mistier93418713misti_er
mistime11312613mistime_
mistimes12612613mistimes
mistitled1246273mistitled
mistuned1157723mistuned
mistyped1685173mistyped
misused104111283mis_used
misyoke1635823misyoke_
misyokes1735513misyokes
mosaicked1842483mosaicked
mosslike1435453mosslike_
musicked1734033musicked
muspike1536043muspike_
muspikes1635233muspikes
niblike1336703niblike_
piglike14157313piglike_
puslike1347563puslike_
riblike1337333riblike_
risked115514633ris__ked
silked114314813si_l_ked
slaked114318273__slaked
sliced94416313__sliced
slicked144413843__slicked
slimed94915123__slimed
slinked123011383__slinked
sliped95417063__sliped
spiked134915553__spiked
tinlike11248803tinlike_
unliked122411283_unliked
unslaked1338463unslaked
unsliced1138093unsliced
viselike1536923viselike_
visited1168773vis_ited
wiglike15125853wiglike_
willied114611563willi_ed
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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621947.46619577.0
3Display Results1941940.0802425.0
 (SQL Overall)1786911947.70223200.6
 
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.