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 “seaboots” 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
seaboots104709(None) 
seaboot9512331seaboot_
reboots93512092re_boots
sabots8314702s_ab_ots
seafoods1245672seafoods
seaports1038462seaports
slyboots1343382slyboots
abbots1039283__abbots
aborts84916183__aborts
babools11319453_babools
baboons113211083_baboons
baboos103517013_baboo_s
boots75837973___boots
cahoots1238473_cahoots
deadbolts1343103deadbolts
ebooks12358333_e_books
enroots738713_enroots
freeboots1444043freeboots
gaboons10289903_gaboons
galoots82410793_galoots
gumboots1344253gumboots
haboobs1495463_haboobs
jabots1538883_jab_ots
peacoats1247833peacoats
readopts1146493readopts
readouts938903readouts
reallots837993reallots
rebooks134010513re_books
reboot84119333re_boot_
redroots937753redroots
reshoots11228413reshoots
sabbats1138633s_abbats
sabot7931783s_ab_ot_
saloons74415323s_aloons
saloops93510133s_aloops
scabious1246593scabious
scabrous1245993scabrous
scoots85315943s__coots
seabags1037483seab_ags
seabeds10417223seab_eds
seabirds1164403seabirds
seaboard1147433seaboard
seaboards1246443seaboards
seaborne1055433seaborne
seacoast1047783seacoast
seacoasts1144193seacoasts
seacocks1645643seacocks
seadogs958643sea_dogs
seafloors1243053seafloors
seafood1146153seafoo_d
seafowls1443663seafowls
seafronts1244383seafronts
sealants82610743sealants
sealifts1135473sealifts
seamounts1143683seamounts
seaport9315603seaport_
seascouts1144313seascouts
seasons72614233sea_sons
seatbelts1142983seatbelts
seatrouts946393seatrouts
seats54844343sea___ts
seawants11337973seawants
sellouts837493sellouts
setouts74110333se_touts
sexpots1636293se_xpots
shadoofs1554233shadoofs
shallots11319503shallots
sheroots1137863sheroots
shoots94619363s__hoots
snoots64216683s__noots
soots55536213s___oots
spambots1443313spambots
steamboats1452493steamboats
subabbots1241873subabbots
sublots92410913s_ublots
symbiots1573623symbiots
taboos83815433_taboo_s
teabowls1343463teabowls
teaboxes1745063teaboxes
teapots939053tea_pots
tearooms1047843tearooms
yearbooks1842573yearbooks
zealots1636763zea_lots

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 Limit146162836.92021121.7
3Display Results83830.0332515.2
 (SQL Overall)178691837.35924282.0
 
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.