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

83 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
boredoms134604(None) 
boredom1236941boredom_
boresome1248402boresome
bossdoms1343732bossdoms
dogedoms1344332dogedoms
foredoes12310802foredoes
foredooms1544792foredooms
popedoms1545282popedoms
whoredoms1843362whoredoms
barrooms1237893barrooms
bedims1149593b__edims
besoms105712733b__esoms
birddogs1382433birddogs
boleros9310293bolero_s
booms95427123bo___oms
bordels103911973bor_dels
borders104317533bor_ders
boreas85421733bore__as
boreases10310253boreases
borecole1246623borecole
borecoles1345973borecoles
bored85034303bored___
boreens9310403bore_ens
borehole1347623borehole
boreholes1447353boreholes
borers85122683bore__rs
bores76448253bore___s
borides10515153borid_es
borneols1046343borneols
borons85520543bor__ons
borrows12349253bor_rows
borzois1835833bor_zois
bosoms104913053bo__soms
bossdom1244243bossdom_
bottoms1136993bo_ttoms
bourdons1136433bourdons
breams104815043b_re_ams
bredes94818473b_red_es
brooms104915873b_r_ooms
coeloms1139063co_eloms
comedos12329073comedo_s
condoms124214083co_ndoms
cordons104415763cor_dons
coredeems1443003coredeems
credos94612853_credo_s
dogdoms1295423do_gdoms
dogedom1244663dogedom_
dorados938203dorado_s
dukedoms1642393dukedoms
earldoms1144223earldoms
firedogs1344793firedogs
fordoes11311963for_does
forearms1336603forearms
forebooms1645333forebooms
foredo10510823foredo__
foredone1249733foredone
foredoom1445813foredoom
foregoes1239523foregoes
foretops13137483foretops
freedoms1445433freedoms
hoteldoms1563123hoteldoms
jarldoms1842943jarldoms
lordoma1056043lor_doma
lordomas1145083lor_domas
moviedoms1751813moviedoms
ordos65216203_or_do_s
popedom1445453popedom_
redoes74623763__redoes
redons75222183__redons
redos65126763__redo_s
reredos838633reredo_s
serfdoms1443763serfdoms
sodoms989673so__doms
sordors8310013sor_dors
teredos839183teredo_s
toledos8388863toledo_s
toreadors1045153toreadors
toreros7311343torero_s
torpedoes1243943torpedoes
torpedos1143933torpedo_s
uredos73910623_uredo_s
whoredom1743283whoredom_
wifedoms1743463wifedoms

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 Limit146162837.51319454.5
3Display Results83830.0332515.2
 (SQL Overall)178691837.95222471.2
 
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.