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

84 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
bottomer124510(None) 
bottomed1344671bottomed
bottomers1344351bottomers
boomer104618512bo__omer
bottler94211882bott_ler
bottom1048722bottom__
bottomry1542042bottomry
bottoms1136992bottom_s
buttoner1036972buttoner
battener10369393battener
batter84928873batt__er
batterer102713213batterer
battier93515713batt_ier
battler94113383batt_ler
bestower13126213bestower
better84723703bett__er
bettor83612223betto__r
bitter84622673bitt__er
bitterer10309773bitterer
bittier94211663bitt_ier
bloomer11419813b_loomer
blotter94612853blott__er
blottier10336413blott_ier
boater84622093boat__er
boatmen1146913boat_men
boatsmen1245283boatsmen
boilover1344023boilover
bolter83920753bolt__er
booger94816553bo__oger
booker124719193bo__oker
boomed115318133bo__omed
boomers114115913bo__omers
boomier113312183bo__omier
boozer174815963bo__ozer
borrower1384833borrower
bosomed1238003bo_somed
botcher143613223bo_tcher
botchier15287143botchier
bother115218063bo_t_her
botonee9311833bo_tonee
bottle84916073bott_le_
bottled104611233bott_led
bottlers103810013bott_lers
bottles94216273bott_les
bottoming1444433bottoming
bottomless1442053bottomless
bottomries1443083bottomries
butter84724233butt__er
buttoned1137503buttoned
buttoners1145703buttoners
buxomer1833243b_uxomer
costumer1275103costumer
cottager11306813cottager
cotter84926673cott__er
cottier93814173cott_ier
cottoned1138033cottoned
customer1245383customer
dotter74419343dott__er
dottier83910923dott_ier
fathomer1645293fathomer
hotter94720083hott__er
ionomer939833io_nomer
jotter134315633jott__er
kotower1434383ko_tower
kowtower1842273kowtower
lotter64025603lott__er
monomer11311893mo_nomer
motioner1037593motioner
mottler94410343mott_ler
mottoes93412193motto_es
otter54423973_ott__er
ottoman946283_ottoman
outhomer1348133outhomer
outtower1136193outtower
potter83926983pott__er
potterer102310263potterer
pottier93516493pott_ier
roomer84718633ro__omer
rottener8216973rottener
rotter64325463rott__er
tattooer844373tattooer
tautomer1044593tautomer
totter65021463tott__er
totterer8217793totterer

Search took 9 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.860207780.2
2DLD Change Limit146162847.81318707.5
3Display Results84840.0302800.0
 (SQL Overall)178691848.70320532.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.