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

109 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
degasser1032581(None) 
degassed11275961degassed
degassers11354831degassers
degasses10278361degasses
degausser1172161degausser
debaser103510412deba_ser
degases93413102dega_ses
degaussed1242542degaussed
degaussers1241662degaussers
degausses1143202degausses
detassel943652detassel
gasser75017772__gasser
megasse10266242megasse_
megasses11307742megasses
amasser9418733_amasser
avgasses1284193avgasses
bagasse1035143bagasse_
bagasses1136313bagasses
classer93614613_classer
crasser94114333_crasser
dasher104318983d__asher
deader84220473de_a_der
deafer104114813de_a_fer
dealer74122143de_a_ler
dearer74822803de_a_rer
deashed123411303de_ashed
deashes113313903de_ashes
debarker15155503debarker
debase94014473deba_se_
debased113310583deba_sed
debasers11377903deba_sers
debases103814133deba_ses
debater104114693deba_ter
decanter112510793decanter
decayer13339353deca_yer
declasse1165943declasse_
declassed1344993declassed
declasses1246443declasses
deemster1175713deemster
defacer132810363defa_cer
defamer132710323defa_mer
defuser115110503de_fuser
degage92711383dega_ge_
degame102713183dega_me_
degames113312623dega_mes
degas75119163dega_s__
degassing1234823degassing
degauss933923degaus_s
degender1136893degender
degrader11247913degrader
degreaser1144333degreaser
degusted1135733degusted
delayer113010533dela_yer
delouser936363delouser
deluster936903deluster
demander12238723demander
demasted1238763demasted
demister11310223demister
dempster1355773dempster
denser74115193de__nser
deposer104011843de_poser
deranger1037353deranger
desalter938363desalter
despiser1136343despiser
dessert82916453de__ssert
detacher1437543detacher
detailer9268673detailer
detainer92910793detainer
detassels1042673detassels
detester9239683detester
deviser114212393de_viser
dewater112912423dewa_ter
diaster82813313d_iaster
digester10258423digester
disaster949943disaster
dosser74417973d__osser
dragster1034623dragster
dresser83611953d_resser
easier64218463_e_asier
easter65027983_e_aster
eraser64216333_era_ser
eyasses10388023_eyasses
feaster10812983fe_aster
gasher104320373__gasher
gasper94515543__gasper
gassed85217633__gassed
gassers84714633__gassers
gasses75724783__gasses
gassier83812573__gassier
gaster75027353__gaster
harasser1137033harasser
leaser65322673le_a_ser
lesser63514853le__sser
megass9219443megass__
megastar1143533megastar
merganser1242843merganser
negater83711953nega_ter
passer84721033__passer
reassert8313673re_assert
regainer9249353regainer
regaler83814623rega_ler
regather1236733regather
regisseur1041543regisseur
register939553register
relapser1035273relapser
remaster10311473remaster
repassed11229273repassed
repasses101810373repasses
teaser65421523te_a_ser

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.1731032896.0
2DLD Change Limit1461621098.47017256.4
3Display Results1091090.0462369.6
 (SQL Overall)1786911098.68920565.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.