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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

129 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
dromond113547(None) 
dromon939361dromon_
dromonds1244611dromonds
dromons1038191dromons
diamond1186112diamond
drownd11478312dro_wnd
promoed12310082promoed
almond91410433_almond
around72712413aro_und
bromid112612893brom_id
bromin102615693bromin_
bromine112915243bromine
bromins112513783bromins
bromo95217203bromo__
bromos104213313bromo_s
brood84620243bro_o_d
broomed124111053broomed
cormoid12310403cormoid
croon75522783cro_on_
crooned103813343cro_oned
croons85418423cro_ons
croton84415453croton_
crotons93714373crotons
daemon9279593daemon_
daemons10269233daemons
daimon9259713daimon_
daimons10249323daimons
demand104314253d_emand
demoed103713443d_emoed
demon86520313d_emon_
demons94917723d_emons
deodand1035713deodand
dermoid1138523dermoid
desmoid1137103desmoid
despond1137513despond
diamonds12125173diamonds
domed95423263d_om_ed
domine92918253d_omine
doming104218393d_oming
domino92611493d_omino
doomed104113293doom_ed
dooming113112533dooming
dormant102814373dormant
dormin9312313dormin_
dormins10311273dormins
dragon838843dragon_
dragons938383dragons
drammed13378073drammed
droid74218543dr__oid
drolled93810223drolled
drone65324983dr__one
droned84616863dro_ned
droning93013723droning
drool65416103dro_o_l
drooled9369203drooled
drools74412813dro_ols
drooly104911073dro_oly
droop85814823dro_o_p
drooped11368433drooped
droops95110963dro_ops
droopy12458243dro_opy
dropout10410003dropout
dropped13329283dropped
dropsonde1342543dropsonde
drouked1335543drouked
droved114611643dro_ved
droving12379683droving
drown95515823dro_wn_
drownds12346153dro_wnds
drowned12419903drowned
drowns105612333dro_wns
drowsed12448743drowsed
drummed13306323drummed
dryland1254303dryland
duomo839753duomo__
duomos936823duomo_s
duotone836893duotone
frond95316343fr__ond
gnomon936183gnomon_
gnomons1035753gnomons
gormand1157453gormand
groomed11379503groomed
ground82310273gro_und
hormone12410503hormone
jomon14610083_jomon_
kroon94514483kro_on_
krooni10397183kro_oni
kroons103711243kro_ons
orotund844063orotund
premold1247863premold
proband122710243proband
profound1444923profound
prolong10319633prolong
promine112819443promine
promo95620003promo__
promoing13310463promoing
promos105116423promo_s
promote11313143promote
promoted13310543promoted
propend123311273propend
propone112716303propone
proponed132412033proponed
propound1346393propound
protend104012793protend
proton84318893proton_
protons93118003protons
ramona8412413_ramona
remand95618963_remand
remend95216553_remend
remind94819793_remind
remold93412973_remold
roband92310723_roband
roman75424823_roman_
romano84912943_romano
romans84620243_romans
romped114513653_romped
rood56733003_ro_o_d
roomed95218543_roomed
rotund737293_rotund
round64318433_ro_und
somoni8310743_somoni
towmond1394203towmond
trogon73611753trogon_
trogons83410723trogons
troland837543troland
trombone1245373trombone
tromped124210293tromped
uropod937263uropo_d
vroomed13366433vroomed

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271296.95319276.1
3Display Results1291290.0502580.0
 (SQL Overall)1786911297.39324170.3
 
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.