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 “megrims” 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
megrims127610(None) 
begrims1276761begrims
megrim1178041megrim_
begrim11118332begrim_
begrime1276552begrime
begrimes1376512begrimes
megohms1592862megohms
merits8320872me_rits
metrics11312362metrics
retrims93612372retrims
aegis6316783aeg_i_s
aeries64737783ae_ries
agrias74315393_agrias
becrime1387053becrime
becrimes1467073becrimes
bedims1149593be_dims
begins94415303beg_ins
begirds1134883begirds
begrimed1475213begrimed
begums11429493beg_ums
berime105317333be_rime
berimes115216643be_rimes
berms95323663be_r_ms
berries94423553berries
brims94721623__brims
cerias83321973ce_rias
ceriums1139473ce_riums
dearies83526273dearies
debris93311493debri_s
decries103319803decries
degamis11268433degamis
degerms1135623degerms
degrees92810723degrees
degums10438623deg_ums
denims95214323de_nims
dermis94717163de_rmis
derms85022893de_r_ms
derries83124623derries
derris73615273derri_s
egis56520653_eg_i_s
egoism977473_egoism
egoisms1065953_egoisms
egress73310433_egress
egrets72712243_egrets
emeries91620023emeries
engrams1038073engrams
eyries93816813_eyries
ferias95020393fe_rias
fermis114313503fe_rmis
ferries103521083ferries
ferrums1265983ferrums
germs85118873ge_r_ms
glims87417673__glims
grams85327313__grams
grids75321393__grids
grigs75318193__grigs
grim76929423__grim_
grime85021323__grime
grimes94619033__grimes
grimy114312603__grimy
grins65427223__grins
grips85520133__grips
grits65529583__grits
hegaris11310423hegari_s
hegiras1136103hegiras
henries102718283henries
herms105626433he_r_ms
herries104025073herries
jerids142810943je_rids
jerrids15277743jerrids
jerries143817513jerries
kelims1278913ke_lims
kermis124012393ke_rmis
kerrias11289513kerrias
kerries113317913kerries
leggins9259473leggins
legits71313003leg_its
legrooms1185413legrooms
magics115311613mag_ics
magnums1234683magnums
magpies12310363magpies
maims96321783m__aims
margins103815193margins
marrams11310123marrams
marries93825283marries
maxims17399673m_axims
mealies92821933mealies
meanies93620743meanies
medias93620783me_dias
medics114115353me_dics
mediums12308723mediums
medius93613283me_dius
megabits1355793megabits
megahits1445683megahits
megass9219443meg_ass
megilp1135833meg_ilp
megilps1233563megilps
megohm14124193megohm_
megs75530633meg___s
meinies92516073meinies
meloids10911443meloids
memoirs1136803memoirs
memories121214343memories
mems85931503me___ms
menhirs1235913menhirs
merces105720743me_rces
mercies113817563mercies
mercs96020453me_r_cs
merdes94518603me_rdes
meres75143573me_r_es
mergees104411233mergees
mergers103813423mergers
merges94122483me_rges
merging112711753merging
merino8315093me_rino
merinos9311973me_rinos
merises93421423me_rises
merisis93213173me_risis
merit7339183me_ri_t
merks114722403me_r_ks
merles85322763me_rles
merlins93015803merlins
merls77423903me_r_ls
merrier92612303merrier
merriest10311473merriest
merrily1238633merrily
meseems1165603meseems
metis75025903me_ti_s
metres85121563metr_es
metric10314673metri_c
metrify1535623metrify
metring103215283metring
metrist9317063metrist
metrists1039843metrists
metritis1049183metritis
metros84217803metr_os
midribs1235493midribs
minims104514803m_inims
mirins83918893m_irins
misaims11310113misaims
moggies113111723moggies
morris83814723morri_s
muggins11248073muggins
murids93212193m_urids
murries94118673murries
negroids10116323negroids
ogrism937913_ogrism
ogrisms1036443_ogrisms
peeries93623023peeries
perils84121853pe_rils
peris75537073pe_ri_s
perms95524513pe_r_ms
perries93226603perries
pilgrims1344143pilgrims
pogroms1237643pogroms
pretrims1238983pretrims
prims95425933__prims
rearms85114653rear_ms
redries83721713redries
refries104419733refries
regains84316583regains
regime95313943reg_ime
regimes104514743reg_imes
regius7311923reg_ius
regress82711453regress
regrets83212923regrets
regrind938983regrind
regrinds1035533regrinds
regrooms1196013regrooms
regrows11269153regrows
rerigs74014793re_rigs
retries74129073retries
retrim83514873retrim_
rims65936303___rims
scrims104615933_scrims
series64540973se_ries
serifs94017053se_rifs
serins64029673se_rins
serries73925353serries
serums83916303se_rums
terms75523473te_r_ms
terries73425613terries
territs72714493territs
tetris62816293tetri_s
trims75021473__trims
tugriks1233153tugriks
untrims938613untrims
veeries102916883veeries
veggies1237553veggies
vegies104314273veg_ies
verism113214263ve_rism
verisms123011253ve_risms
vermis114214963ve_rmis
wearies103020223wearies

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271947.84617082.2
3Display Results1941940.0633079.4
 (SQL Overall)1786911948.06522156.4
 
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.