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

312 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
machines1531288(None) 
machine14313491machine_
machined1637301machined
achenes12313492_achenes
achiness1339702_achiness
archines133815252archines
chines115029172__chines
kachinas1736332kachinas
maches134827232mach__es
machetes1539632machetes
machinates1747322machinates
machinery1943092machinery
machinist1648482machinist
machrees1545502machrees
malines93625602ma_lines
marines93928012ma_rines
marlines103818712marlines
mashies12318252mashi_es
rachides141511222rachides
rachises131412412rachises
tacrines10310562tacrines
vaccines1536502vaccines
vahines133410522va_hines
wahines133111172wa_hines
acarines10314343_acarines
achene11313813_achene_
aches106132293_ach__es
achier113914263_achi_er
achiest12315183_achi_est
achieves1645523_achieves
aching126521973_achin_g
achiotes1339003_achiotes
acinus8311253_ac_inus
acnes75922623_ac__nes
actings104512463_actings
actins86321103_actin_s
actives12311523_actives
affines1339483_affines
alines65735223_a_lines
alkines114415733_alkines
alpines94016193_alpines
amidines113010853amidines
amines84727983_a_mines
ammines11312673_ammines
aphides134711203_aphides
archine125817053archine_
archings14499863archings
archives16399553archives
arcsines104010343arcsines
arsines73518813_arsines
ashiness1138963_ashiness
azines155517073_a_zines
baches135426943bach__es
baching156017753bachin_g
backings174012213backings
bashings144311243bashings
caches137926913cach__es
caching156317503cachin_g
calcines12314753calcines
camphines1847563camphines
canines93724033ca_nines
carbines123617533carbines
carlines103521643carlines
carmines123617863carmines
cassines103116613cassines
chaines124518733__chaines
chides124620473__chides
chiles115425303__chiles
chimes134922573__chimes
chinas115119383__chinas
chine105231723__chine_
chined125620063__chined
chinks155817573__chinks
chinos115018693__chinos
chins105631463__chin_s
chints115117833__chints
chives144317593__chives
cines75239683__c_ines
clines84926043__clines
cocaines121314443cocaines
cochins141413093cochin_s
dacites101114593dac_ites
daphnes13327683daph_nes
dauphines1544343dauphines
declines113315793declines
duchies133312313duchi_es
echinus1236203_echinus
errhines1136403errhines
etchings14396293etchings
eucaines1038503eucaines
facies113921593fac_i_es
facings134511263fac_ings
famines123216263fa_mines
fanzines2036913fanzines
fascines13310143fascines
fuchsines17103333fuchsines
gamines103618463ga_mines
hachures1645873hachures
hackies163418243hacki_es
harmines132715133harmines
hatchings18225673hatchings
imagines1137463ima_gines
inclines10313133inclines
itchiness1444753itchiness
itchings14386193itchings
jackies202912623jacki_es
jasmines1736623jasmines
jawlines18126363jawlines
kachina1637663kachin_a
kaolines1239283kaolines
katchinas1843923katchinas
laches116528343lach__es
laciness102112553lac_iness
lacings105013653lac_ings
lactones10311223lactones
lacunes9159623lac_unes
lashings124412253lashings
lashins103915153lashin_s
lathings12469853lathings
latrines8515003latrines
lauwines1145713lauwines
lawines103313563la_wines
macaques2143953macaques
macchie1647193macchi_e_
macedoines1552953macedoines
maces97139963mac___es
mache125925303mach__e_
machete14310883machete_
machinate1647953machinate
machinated1845663machinated
machineries1853783machineries
machining1746933machining
machinists1745303machinists
machismo1754203machismo
machismos1863053machismos
machoisms1845193machoisms
machos135217493mach__os
machree1438513mach_ree
machs125722563mach___s
machzors2444113machzors
macing114221553mac_in_g
mackinaw1943103mackinaw
mackinaws2042433mackinaws
mackles154415753mac_kles
macles107023223mac__les
macons104017243mac_on_s
macrames1438953macrames
macrons113514893macron_s
macules114015133mac_ules
madrones112912283madrones
magazines2145633magazines
magpies12310363magpi_es
mahoes11313103ma_h_oes
mailes84329113ma__iles
mailings113011923mailings
mainlines1138513mainlines
mains75635093ma__in_s
maizes175115733ma__izes
makings145413153ma_kings
malachites1785073malachites
malaises10312333malaises
malices114316623ma_lices
malihinis1443833malihinis
maline84529083ma_line_
malkins133311803malkin_s
mallings113413093mallings
maltiness112910573maltiness
mamies104626243ma_mi_es
mammies104314763mammi_es
manches143818623manch__es
manchineel1752113manchineel
manchineels1851253manchineels
manes76648953ma___nes
manginess122010413manginess
manholes13311183manholes
manhunts1344043manhunts
manliness111310123manliness
mannites10312613mannites
mantises10317923mantises
mappings15296413mappings
marches143921173march__es
marching164312193marchin_g
marchioness1842733marchioness
marchpanes1943603marchpanes
margined1237743margined
margins103815193margin_s
marinas93519373ma_rinas
marine84230403ma_rine_
mariner93315993ma_riner
mariners103113863ma_riners
markings153410233markings
marline93320953marline_
marlings113713483marlings
marlins93420473marlin_s
marlites103415263marlites
marmites122212793marmites
marries93825283marri_es
marshiness1555063marshiness
martinet10319643martinet
martinets1138883martinets
martinis103311613martinis
martins93322063martin_s
masculines1445513masculines
mashes115030003mash__es
mashie11315933mashi_e_
mashing134422243mashin_g
maskings15448743maskings
massiness112810143massiness
mastixes1738253mastixes
matches143219783match__es
matching163512393matchin_g
matinee92415613ma_tinee
matinees102110423ma_tinees
matiness102114743ma_tiness
matings104516203ma_tings
matins84527783ma_tin_s
matrices12312083matrices
matrixes1738063matrixes
mattings11369673mattings
mattins93316143mattin_s
mavies114923193ma_vi_es
mavins115119183ma_vin_s
mavises122812993ma_vises
maxixes1535253ma_xixes
mayings134410503ma_yings
mayvins1535323mayvin_s
maziness19239543ma_ziness
methanes133812163methanes
methinks1775193methinks
miches134320733mich__es
miching152911803michin_g
midlines112613333midlines
millines102718063millines
mines75651953m___ines
mochilas1544943mochilas
moraines10314343moraines
morphines1648223morphines
moshings14367323moshings
muches134718993much__es
muchness1534073much_ness
mucins102712513muc_in_s
mucrones1237603mucrones
munchies1539253munchi_es
murines93718223m_urines
mushiness14248213mushiness
mutines93117823m_utines
myelines1337123myelines
naches114622413nach__es
narceines1146583narceines
orchises1338773orchises
oscines9310363osc_ines
pachinko1942303pachinko
pachinkos2042403pachinkos
pachisis15268823pachisis
packings174310063packings
patchiness1744933patchiness
patines95225763pa_tines
pectines121914673pectines
rachis114017653rachi__s
rachitis1348353rachitis
raciness102413453rac_iness
racings105015123rac_ings
raphides14188393raphides
rapines95120863ra_pines
ratines75328583ra_tines
ratlines83815293ratlines
ravines104220233ra_vines
rawhides15145543rawhides
reclines103718543reclines
reshines112615443reshines
rhachides1853663rhachides
rhachises1763973rhachises
ruchings14287073ruchings
sabines94318483sa_bines
sackings15389633sackings
sacrings11278923sacrings
salines74029413sa_lines
saltines82917793saltines
sardines92815563sardines
savines104417633sa_vines
shines95028913__shines
smaltines1136993smaltines
taches114224173tach__es
tachinid1446243tachinid
tachinids1544043tachinids
tachismes1684223tachismes
tachisms1567143tachisms
tachistes1466043tachistes
tachists1348183tachists
tackiness1557693tackiness
tacrine9311293tacrine_
taglines92210823taglines
tahinis1048003ta_hinis
taurines8310543taurines
teachings15296553teachings
techies12513603techi_es
urchins1238863urchin_s
vaccinas1544973vaccinas
vaccine1437323vaccine_
vaccinee1544853vaccinee
vaccinees1642843vaccinees
vahine123612113va_hine_
valines104520213va_lines
vichies15310623vichi_es
wackiness1836523wackiness
wahine123813013wa_hine_
washiness1537043washiness
washings15419273washings
whines125120103__whines
xanthines1966723xanthines
yachtings1842663yachtings
zechins21137123zechin_s

Search took 9 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.203880251.2
2DLD Change Limit1461623128.06318127.5
3Display Results3123120.1232536.6
 (SQL Overall)1786913128.38921300.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.