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 “megohm” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

76 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
megohm1412419(None) 
megohms1592861megohms
megrim1178042megrim
abohm1247973_abohm
begloom1255243begloom
begone9512133begone
begot84625953bego_t
begrim11118333begrim
begum105213923beg_um
besom95716973beso_m
beworm1339993beworm
celom9515693celo_m
defoam1238563defoam
deform1259623deform
degerm1037893degerm
degum94711903deg_um
deworm1249533deworm
ego46726053_ego__
egoism977473_egoism
egos55821653_ego_s
enorm74415643_enorm
genom83716843geno_m
gorm75529393__gorm
legong836963legong
legroom1076093legroom
magnum1136733magnum
magot8326393mago_t
magots9312363magots
medium113711623medium
meg66040953meg___
mega77620873meg__a
megahit1378773megahit
megara9310093megara
megass9219443megass
megilp1135833megilp
megrims1276103megrims
megs75530633meg__s
melody1237203melody
meloid9616003meloid
melon73922083melo_n
melons84117713melons
mem77943473me___m
memo85924793memo__
memoir1037213memoir
memory1338803memory
memos95719113memo_s
meno66031363meno__
mensh105413553mensh_
mentum104511713mentum
meou65325863me_o_u
meous76120063me_ous
meow95117883me_o_w
meows104612683me_ows
merch125417963merch_
mesh96823003me_sh_
meshy135612783me_shy
meson74118313meso_n
mesons83215843mesons
meth95827843me_th_
method1239023method
meths105320233me_ths
metol75917813meto_l
metols84115773metols
metonym1445573metonym
metope10611123metope
microhm1646123microhm
might113827083mig_ht
mom78853163m__o_m
ohm86523013___ohm
reform11312713reform
regnum957163regnum
regroom1077303regroom
sego56525183sego__
segos64919483sego_s
teraohm1244783teraohm
venom103914863veno_m

Search took 6 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 Filter1786911127160.406440125.6
2DLD Change Limit112716765.43620735.1
3Display Results76760.0164750.0
 (SQL Overall)178691765.85830503.8
 
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.