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

53 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
moonbow144387(None) 
moonbows1543951moonbows
downbow1653392downbow
bonbon10310073_bonbon
bonobo1037143bonobo_
bonobos1136393bonobos
booboo1039463boo_boo
boombox2073613boombox
cornrow1245603cornrow
downbows1783693downbows
fogbow1544783_fogbow
footboy1544913footboy
hoosgow1442763hoosgow
longbow1343863longbow
minnow1135583m_innow
mistbow1443993mistbow
mondo85721233m_ondo_
mondos95217333m_ondos
mongo810122413m_ongo_
mongoe94214983m_ongoe
mongol94912533m_ongol
mongos94318623m_ongos
mono66036723m_on_o_
monocot11412013monocot
monolog10259353monolog
monopod1247493monopod
monos75930863m_on_os
moon67140813moon___
moonbeam1443233moonbeam
mooned94216643moon_ed
mooner85317833moon_er
mooners94015343mooners
mooneye12116933mooneye
moonier93714103moonier
moonily1248943moonily
mooning103415553mooning
moonish123311043moonish
moonlet92413273moonlet
moonlit9229333moonlit
moonport1257193moonport
moonroof1344543moonroof
moons75331003moon__s
moonset92413043moonset
moonshot1346273moonshot
moonwort1367813moonwort
moony104818273moon__y
moorfowl1651873moorfowl
morrow113510093m_orrow
oxbow1734443__oxbow
rainbow1243353rainbow
sunbow1145823_sunbow
toolbox1653633toolbox
woodbox2043693woodbox

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 Limit134027535.78323176.0
3Display Results53530.0163312.5
 (SQL Overall)178691536.20228811.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.