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

71 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
megalops135612(None) 
megaflops1772671megaflops
galops94712622__galops
magalogs1245252magalogs
megaflop1672272megaflop_
megalopic1644162megalopic
megalopses1543552megalopses
megapods1444902megapods
megatons11279702megatons
megilps1233562megil_ps
begalls10319163begal_ls
decalogs1245633decalogs
develops14145323develops
escalops1244673escalops
etalons739073_etalons
gallops103211653__gallops
galop84716223__galop_
gigaflops1651343gigaflops
glops85619553__g_lops
jalops15329593__jalops
jealous1438093je_alous
legals73412733legal__s
legators92811033legators
legatos82711183legato_s
magalog1144913magalo_g
magilps1234083magil_ps
meadows1337333me_adows
mealies92821933me_alies
meals75933373me_al__s
medals94218053medal__s
megabars1344403megabars
megabits1355793megabits
megadose1244493megadose
megadoses1344663megadoses
megahits1445683megahits
megalith1448243megalith
megaliths1544743megaliths
megalopolis1662423megalopolis
megapod1344893megapo_d
megapode1444303megapode
megapodes1544233megapodes
megaron10248303megaro_n
megass9219443mega__ss
megasses11307743megasses
megaton10269853megato_n
megavolt1444573megavolt
megavolts1542703megavolts
megillas1145893megillas
megilp1135833megil_p_
megilph1542263megil_ph
megilphs1641613megilphs
melanous1048603melanous
melilots1046553melilots
mellows123812233me_llows
melons84117713me__lons
menazons1945733menazons
merlons93311273me_rlons
merlots92710123me_rlots
metals84520883metal__s
negatons9299273negatons
negators92411173negators
pedalos10329703pedalo_s
petalous1058973petalous
regalers94311133regalers
regales83520793regal_es
regloss8218023reg_loss
reglows11288843reg_lows
sepalous1047523sepalous
teraflops1443063teraflops
zealots1636763ze_alots
zealous1637813ze_alous

Search took 10 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.826216332.9
2DLD Change Limit146162718.37617450.1
3Display Results71710.0164437.5
 (SQL Overall)178691719.21819385.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.