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

74 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
dromonds124461(None) 
dromond1135471dromond_
dromons1038191dromon_s
diamonds12125172diamonds
dromon939362dromon__
drownds12346152dro_wnds
almonds10127953_almonds
bromids12278603brom_ids
bromines122514253bromines
bromins112513783bromin_s
bromos104213313bromo__s
broods95416383bro_o_ds
croons85418423cro_on_s
crotons93714373croton_s
daemones11209163daemones
daemons10269233daemon_s
daimones11208803daimones
daimons10249323daimon_s
demands114311413d_emands
demons94917723d_emon_s
deodands1144603deodands
dermoids1246163dermoids
desmoids1244973desmoids
desponds1246243desponds
diamond1186113diamond_
domines102918973d_omines
dominos103210193d_ominos
dormins10311273dormin_s
dragons938383dragon_s
droids84712583dr__oids
drones75023433dr__ones
drools74412813dro_o_ls
droops95110963dro_o_ps
dropouts1145003dropouts
dropsonde1342543dropsonde
dropsondes1452673dropsondes
drownd11478313dro_wnd_
drowns105612333dro_wn_s
duomos936823duomo__s
duotones937643duotones
fronds106412343fr__onds
gnomons1035753gnomon_s
gormands1266563gormands
grounds9228313gro_unds
hormones13311163hormones
kroons103711243kro_on_s
premolds1345843premolds
probands13228393probands
profounds1543933profounds
prolongs11347613prolongs
promines123018803promines
promoed12310083promoed_
promos105116423promo__s
promotes12314123promotes
propends13249173propends
propones122516963propones
propounds1444963propounds
protends113010353protends
protons93118003proton_s
ramonas9311093_ramonas
remands104914883_remands
remends105013033_remends
reminds104614793_reminds
remolds10299703_remolds
robands10219863_robands
romanos94311483_romanos
romans84620243_roman_s
roods65125283_ro_o_ds
rounds73615623_ro_unds
towmonds1493493towmonds
trogons83410723trogon_s
trolands936423trolands
trombones1345363trombones
uropods1035873uropo_ds

Search took 8 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.406440125.6
2DLD Change Limit146162747.14020470.9
3Display Results74740.0332242.4
 (SQL Overall)178691747.57923577.1
 
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.