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

144 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
midlife1324830(None) 
midlifer14215791midlifer
midline102315101midline
midwife16225521midwife
birdlife1443482birdlife
kidlike1137062kidlike
midlifers15254932midlifers
midlines112613332midlines
midlist10312512midlist
midlives14287462midlives
midriff1645512midriff
midsize1946392midsize
midwifed18233932midwifed
midwifes17234712midwifes
millime112511402millime
milline92519112milline
mislie83219152misli_e
mislike132914832mislike
mislive122812692mislive
wildlife1543252wildlife
airlift1048583airlift
airlike11310333airlike
airline7315033airline
amidine103613853amid_ine
bedlike14369533bedlike
biblike1536893biblike
billie85019173billi_e
birdlike1535233birdlike
birdlime1343563birdlime
budlike14257873budlike
cilice103213353ci_lice
didie74120563did_i_e
dislike122913453dislike
fadlike15318483fadlike
finlike14279063finlike
gillie74816943gilli_e
girlie73711463girli_e
godlike1387563godlike
highlife1843003highlife
hiplike1637603hiplike
hipline12311423hipline
idle55423763_idl__e
idling8912883_idling
idolise839293_idolise
idolize1737783_idolize
illite63414923_illite
iolite63221983_iolite
jiglike19105333jiglike
kiddie12359393kiddi_e
killie104114893killi_e
life75433733___life
liplike1337283liplike
lowlife1335143lowlife
mainline1039863mainline
malice104818483m_alice
maline84529083m_aline
manlike133012783manlike
maplike15299273maplike
marline93320953marline
marlite92917073marlite
mealie82519813meali_e
mediae94217413med_iae
micrify1744693micrify
midair937993midai_r
midairs1037203midairs
middies113116153middies
middle103414983mid_dle
middling13249343middling
midge95016553mid__ge
midi75628483mid_i__
midis85923413mid_i_s
midland1136613midland
midleg1038553midl_eg
midlegs1156323midlegs
midlists1137523midlists
midrib1138243midri_b
midribs1235513midribs
midriffs1742533midriffs
midsized2144733midsized
midsole1037813midsole
midwifery2151543midwifery
midwived18263553midwived
midwives17274803midwives
milage93414123mi_lage
milding113615453milding
mile66352573mi_l__e
milia72719573mi_li_a
milieu8314113mi_lieu
milium104712683mi_lium
millage103112753millage
mille75029133mi_l_le
milliare1039153milliare
millieme12276803millieme
millier93716703millier
millimes122411373millimes
milliner102811863milliner
millines102718063millines
milling103223683milling
million91813143million
milliped1337383milliped
millirem1245693millirem
minify1439253mi_nify
miscite11314383miscite
misdrive1446683misdrive
misfile122611553misfile
misfire12229893misfire
misgive13339033misgive
mislies92922283mislies
misliked15319513misliked
misliker14319573misliker
mislikes143311833mislikes
mislit83019693misli_t
mislived14328783mislived
mislives132912153mislives
missile92815403missile
missive122413143missive
mistime11312613mistime
modify1537173mod_ify
moline84422033m_oline
mollie83517103molli_e
mollify1555503mollify
mudslide1243593mudslide
mullite9313013mullite
myeline1238253myeline
niblike1336703niblike
nidify1336763nid_ify
nonlife1038553nonlife
oldwife1492253oldwife
piglike14157313piglike
podlike14108553podlike
prelife1279943prelife
redline84218833redline
riblike1337333riblike
rodlike1288263rodlike
sideline91011093sideline
sidle65124033sidl__e
sidling9915423sidling
tidelike1336743tidelike
tillite7313563tillite
tinlike11248803tinlike
vilify1536773vi_lify
widdie113410733widdi_e
wiglike15125853wiglike
willie94116453willi_e

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.393454684.5
2DLD Change Limit1340271446.90619407.3
3Display Results1441440.0602400.0
 (SQL Overall)1786911447.35924282.0
 
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.