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

67 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
megapod134489(None) 
megapode1444301megapode
megapods1444901megapods
decapod1335432decapod
hexapod2043652hexapod
megapodes1544232megapodes
megaron10248302megaron
megaton10269852megaton
apod78123183___apod
begazed2036203begazed
decapods1444623decapods
egad64215413_ega__d
elapid939543_elapid
gaped96123533__gaped
heaped124516903he_aped
hexapods2143403hexapods
hexapody2442313hexapody
leaped94317773le_aped
legated92513983legated
legato72810953legato_
legator83011133legator
legatos82711183legatos
magalog1144913magalog
mead75531603me_a__d
meadow1237403me_adow
meated94222403me_ated
medaled113411613medaled
mega77620873mega___
megabar1244503megabar
megabit12117963megabit
megadose1244493megadose
megaflop1672273megaflop
megahit1378773megahit
megalops1356123megalops
megaphone1744743megaphone
megaphoned1953303megaphoned
megaplex2042513megaplex
megara9310093mega_ra
megaspore1443443megaspore
megass9219443mega_ss
megasse10266243megasse
megatons11279703megatons
megavolt1444573megavolt
melamed1249633melamed
melanoid1147123melanoid
menaced122710093menaced
menad85918983mena__d
menazon1846053menazon
metaled102913883metaled
metaphor1544913metaphor
metazoa1845543metazoa
method1239023me_thod
metopon11137073metopon
monopod1247493monopod
myriapod1641473myriapod
negated93413233negated
negaton8299143negaton
negator83010673negator
reaped94122453re_aped
regaled93615963regaled
regard85215773rega_rd
retaped103814283retaped
seedpod1144013seedpod
teapot8416763te_apot
teapoy1138113te_apoy
tetrapod1145123tetrapod
weapon11288113we_apon

Search took 7 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.403443402.0
2DLD Change Limit134027675.86022871.5
3Display Results67670.0332030.3
 (SQL Overall)178691676.29628381.7
 
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.