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

94 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
sofabed1334331sofabed
sofabeds1451892sofabeds
sowable121610752sowable
affable15117403affable
coatee84327223co_atee
codable12311663codable
coffee144113743cof_fee
doable93115243do_able
dowable13189453dowable
effable15106673effable
fable105824753__fable
goatee73219533go_atee
isolable1038793isolable
kokanee1044803kokanee
losable91910953losable
lovable12179553lovable
movable14189433movable
notable92114903notable
pokable15209503pokable
posable112212783posable
potable112115363potable
ropable111611333ropable
rowable121510303rowable
sabe66140573s__ab_e
sabed86526813s__abed
saber75330243s__aber
sabes76437463s__abes
sable74732163s__able
sabre74821503s__abre
salable91415463salable
saree55044663s__aree
savable121711863savable
sayable121411613sayable
seabed95017693s_eabed
seeable91113943seeable
sewable121911173sewable
showable1636583showable
sizable1839893sizable
skiable1338883skiable
smokable1636223smokable
soaked114717593so_aked
soaker105717533so_aker
soaped95817973so_aped
soaper84517873so_aper
soared74324293so_ared
soarer64522243so_arer
soave84219053so_a_ve
soaves94218673so_aves
sobbed113516263so_bbed
sobber104016593so_bber
sober74822413so__ber
socage91012123soca_ge
socager10107703socager
socages101012053socages
sociable1239503sociable
sofa75625603sofa___
sofar86115493sofa__r
sofars94712783sofa_rs
sofas85320713sofa__s
soften9429493sof_ten
softer94015313sof_ter
softie93312483sof_tie
softies103414613softies
soignee8279133soignee
soiree62919483so_iree
solace83415823sola_ce
solaced102911063solaced
solacer93011103solacer
solaces93116133solaces
solate64526073sola_te
solated83618023solated
solates73523853solates
soluble966103soluble
solvable1337473solvable
somber103714003so_mber
sombre10729473so_mbre
sonance9310313sonance
sorbable1239303sorbable
sorbate9311733sorbate
sorbed94916523so_rbed
sorbet83924083so_rbet
sortable10312483sortable
spahee11313443s_pahee
stable83921643s_table
stonable1039843stonable
storable10310733storable
stowable1337613stowable
suable83920553s_uable
surfable1338443surfable
toffee123311013tof_fee
totable92313363totable
towable121910113towable
vocable14189673vocable
votable122111373votable

Search took 7 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.393454684.5
2DLD Change Limit134027946.48320673.6
3Display Results94940.0332848.5
 (SQL Overall)178691946.90925863.5
 
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.