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

311 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
midlines11261334(None) 
midline102315111midline_
midlives14287461midlives
millines102718071millines
airlines8312802airlines
amidines113010852amid_ines
hiplines13310592hiplines
mainlines1138532mainlines
malines93625622m_alines
marlines103818752marlines
middies113116152middi_es
middlings14194312middlings
midlands1245542midlands
midlife13248302midlife_
midlifer14215792midlifer
midlifers15254932midlifers
midlists1137522midlists
midwifes17234712midwifes
midwives17274802midwives
millimes122411372millimes
milline92519122milline_
milliner102811872milliner
milliners11289952milliners
millings113712582millings
mislies92922282misli_es
mislikes143311832mislikes
mislives132912152mislives
myelines1337132myelines
redlines93916082redlines
sidelines10109682sidelines
aiblins9311473aiblin_s
airline7315043airline_
airliner836963airliner
airliners945983airliners
alines65735233__alines
amidine103613853amid_ine_
amidins103713103amid_in_s
amidones11348663amid_ones
anilines8415143anilines
beelines103312803beelines
berlines102315463berlines
bialies93618413biali_es
biddies113514493biddi_es
biddings13397563biddings
billies93923503billi_es
billings113412633billings
biplanes1238573biplanes
birdlimes1443093birdlimes
birlings11359613birlings
bowlines133211623bowlines
bylines1239243_bylines
carlines103521683carlines
cholines132214493cholines
cilices113814023ci_lices
citrines102513133citrines
clines84926043__clines
codeines113114533codeines
codlings123110113codlings
codlins104116243codlin_s
cutlines102413273cutlines
deadlines11138503deadlines
declines113315803declines
dialings10329823dialings
diamines11311643diamines
diazines1838713diazines
diclinies1247833diclinies
diddlies1137593diddli_es
didies84621833did_i_es
dillies84122163dilli_es
dines66449153__d_ines
dislikes132810843dislikes
divines113514723di_vines
dwines105013103__dwines
felines104718073_felines
figulines1345043figulines
filings115213073fi_lings
fillies103420253filli_es
fillings122910503fillings
fishlines15246843fishlines
giddies103713363giddi_es
giddiness1234693giddiness
gildings11356973gildings
gillies84120963gilli_es
girlies83013703girli_es
godliness1136593godliness
godlings11367493godlings
guidelines1243363guidelines
gumlines11238573gumlines
guylines12236943guylines
hairlines1237143hairlines
headlines13119013headlines
hemlines13310623hemlines
hidings12349703hid_ings
hildings13347503hildings
hilliness1248923hilliness
hipline12311423hipline_
hotlines11811643hotlines
hyalines14169333hyalines
idleness936843_idleness
idles66720123_idl__es
idling8912883_idlin_g
idolises938763_idolises
idolizes1837553_idolizes
illites72415013_illites
imagines1137463imagines
imines84918353_i_mines
implies11312123impli_es
inclines10313143inclines
indulines1057763indulines
intines7921113_intines
iodines83616633_iodines
iolites73819483_iolites
isolines8312303isolines
jawlines18126373jawlines
kaolines1239303kaolines
kiddies133412283kiddi_es
kidlike1137063kidlike_
killies113318113killi_es
killings133710483killings
kindliness1544043kindliness
kindlings15195273kindlings
kitlings13318103kitlings
landlines1039763landlines
lifelines12147053lifelines
lilies63021413li_li_es
lines57054573___lines
machines15312903machines
madeleines1343613madeleines
madrones112912283madrones
mailings113011933mailings
mainline1039873mainline_
mainlined1254363mainlined
mainliner1144683mainliner
mainliners1244013mainliners
malices114316633m_alices
maline84529103m_aline_
mallings113413103mallings
mandolines1347103mandolines
manliness111310133manliness
marines93928043m_arines
marline93320983marline_
marlings113713513marlings
marlins93420493marlin_s
marlites103415283marlites
mealies92821933meali_es
mealiness11310063mealiness
medflies1435553medfli_es
medicines1447903medicines
medinas103411463med_inas
merlins93015823merlin_s
midairs1037203midai_rs
middens11379383midden_s
middles113415303mid_dles
middling13249343middlin_g
midges103516483mid__ges
midis85923423mid_i__s
midland1136613midlan_d
midleg1038553midl__eg
midlegs1156323midl_egs
midlist10312513midli_st
midpoints14103803midpoints
midranges1344653midranges
midribs1235513midri_bs
midriffs1742533midriffs
midsize1946393midsize_
midsized2144733midsized
midsoles1137763midsoles
midwife16225523midwife_
midwifed18233933midwifed
midwinter1542853midwinter
midwinters1642483midwinters
midwived18263553midwived
miffiness1734523miffiness
migraines1286933migraines
milages103114403mi_lages
mildened1235773mildened
mildens10339933milden_s
milding113615453mildin_g
mildness1136523mi_ldness
miles74645073mi_l__es
milieu8314113mi_li_eu
milieus939803mi_lieus
milkiness1536523milkiness
millages113212903millages
milles84526563mi_l_les
milliares1149403milliares
milliemes13255843milliemes
millier93716703milli_er
milliers102611903milliers
millime112511403millime_
millinery14336103millinery
milling103223683millin_g
millions101712433millions
milliped1337383milliped
millipeds1444703millipeds
millirem1245693millirem
millirems1344323millirems
milneb1095953mi_l_neb
milnebs11113793mi_l_nebs
mines75651953m___ines
minings103912073mi_nings
minnies93617363minni_es
miriness10310463mi_riness
mirins83918903mi_rin_s
misbinds1345163misbinds
miscites12313783miscites
misdefines1644463misdefines
misdoings1344423misdoings
misdrives1546213misdrives
misfiles133110983misfiles
misfires132210583misfires
misgives14329293misgives
mislie83219153misli_e_
mislike132914833mislike_
misliked15319513misliked
misliker14319573misliker
mislikers15317063mislikers
mislive122812693mislive_
mislived14328783mislived
missies93423983missi_es
missiles103015083missiles
missises103513693missises
missives133212843missives
mistimes12612613mistimes
mistiness111911633mistiness
mistunes10311133mistunes
mitises9315543mi_tises
modelings1335573modelings
modernes1138423modernes
moldiness12227053moldiness
moldings12267203moldings
molies84429513m_oli_es
moline84422043m_oline_
mollies93420233molli_es
moraines10314383moraines
moulins9312703moulin_s
muddies113513953muddi_es
muddiness1334763muddiness
mudslides1343233mudslides
muhlies1238933muhli_es
mullites10411643mullites
murines93718233m_urines
muslins9312213muslin_s
mutines93117823m_utines
myeline1238263myeline_
myelins1237353myelin_s
oiliness8311563oi_liness
oodlins83210513oodlin_s
opalines10311423opalines
ordines83014903ord_ines
outlines82418093outlines
picolines1339623picolines
pidgins11259123pidgin_s
pilings103313613pi_lings
pipelines13178353pipelines
potlines10714213potlines
pralines102217743pralines
prolines102619693prolines
purlines103514073purlines
ratlines83815303ratlines
reclines103718543reclines
redline84218833redline_
redlined103811233redlined
redliner93510473redliner
redliners10267853redliners
relines75331323_relines
ridgelines12164293ridgelines
ridglings12214183ridglings
ridings93412093rid_ings
riflings12227313riflings
salines74029423_salines
setlines8312743setlines
siblings11108123siblings
sideline91011093sideline_
sidelined11125883sidelined
sideliner10126013sideliner
sideliners11125133sideliners
sidings94011463sid_ings
sidles74721153sidl__es
sidling9915423sidlin_g
silanes72517163si_lanes
sillies73425083silli_es
silliness9510363silliness
simlins9311843simlin_s
skylines1535703skylines
smidgins12314843smidgin_s
splines94718893_splines
sublines10315783sublines
taglines92210843taglines
tidies74721833tid_i_es
tidiness938793tid_iness
tidings93810263tid_ings
tilings84212793ti_lings
tillites8312833tillites
timelines1148443timelines
toplines102412563toplines
towlines112610343towlines
undines8716083und_ines
uridines989513urid_ines
valines104520223_valines
violins10311453violin_s
violones1137383violones
vitrines112610913vitrines
widdies123514033widdi_es
wildings13287933wildings
wildlings14244923wildlings
wiliness1139113wi_liness
willies103920153willi_es
windlings14236723windlings
witlings12328443witlings
zibelines2045733zibelines

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.453394461.4
2DLD Change Limit1461623117.23320207.7
3Display Results3113110.1262468.3
 (SQL Overall)1786913117.81222873.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.