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

157 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
degassed1127596(None) 
degasser10325811degasser
degasses10278361degasses
degaussed1242541degaussed
deashed123411302de_ashed
debased113310582deba_sed
declassed1344992declassed
degases93413102dega_ses
degassers11354832degassers
degausser1172162degausser
degausses1143202degausses
degusted1135732degusted
demasted1238762demasted
detassel943652detassel
gassed85217632__gassed
megasse10266242megasse_
megasses11307742megasses
repassed11229272repassed
amassed10388633_amassed
avgasses1284193avgasses
badassed1244273badassed
bagasse1035143bagasse_
bagasses1136313bagasses
begalled1236023begalled
begazed2036203bega_zed
bekissed1543163bekissed
biassed10418703_biassed
brassed103612373_brassed
bypassed1642713bypassed
ceased94920783ce_a_sed
cessed94615613ce__ssed
chassed134712133_chassed
classed104113653_classed
crevassed1543193crevassed
damasked1643753damasked
dashed115920563d__ashed
deaired9411533de_aired
deaned84620453de_a_ned
deashes113313903de_ashes
deaved114916553de_a_ved
debagged1433723debagged
debarked16175823debarked
debarred12165633debarred
debase94014473deba_se_
debaser103510413deba_ser
debases103814133deba_ses
debated113916083deba_ted
decamped1634963decamped
decanted122310493decanted
decayed14309333deca_yed
deceased1247713deceased
declasse1165943declasse_
declasses1246443declasses
defaced142910973defa_ced
defamed14309833defa_med
defanged1435433defanged
defatted1335673defatted
defensed1336223defensed
defused125211093de_fused
degage92711383dega_ge_
degame102713183dega_me_
degames113312623dega_mes
degas75119163dega_s__
degassing1234823degassing
degauss933923degaus_s
degaussers1241663degaussers
degermed1335453degermed
deglazed2034953deglazed
degraded12288323degraded
degreased1244713degreased
degreed10258883deg_reed
degummed1542603degummed
dehisced1583683dehisced
delated93722873dela_ted
delayed123310763dela_yed
delisted10310563delisted
deloused1036973deloused
demanded13348513demanded
demarked16187223demarked
demised113613683de_mised
departed1238823departed
deposed113412023de_posed
depressed1357623depressed
derailed102410403derailed
deranged1137693deranged
derated93623503dera_ted
deratted1048403deratted
desalted1038313desalted
desanded11227453desanded
desisted1039783desisted
despised1236923despised
detached1537733detached
detailed10319873detailed
detained103111643detained
detasseled1252023detasseled
detassels1042673detassels
detested10279623detested
devalued1335013devalued
devested13239133devested
devised123712563de_vised
dewaxed19316053dewa_xed
digested11208163digested
digressed1245613digressed
dissed85220183d__issed
dogsled1035193dog_sled
dossed84516633d__ossed
dressed93511873d_ressed
eased65430403_e_a_sed
egested938123_egested
egressed1046873_egressed
elapsed1056103_elapsed
erased74816753_era_sed
eyasses10388023_eyasses
feased105718713fe_a_sed
feasted11310843fe_asted
fessed104515063fe__ssed
gashed116321973__gashed
gasped104814293__gasped
gasser75017773__gasser
gasses75724783__gasses
gasted84821583__gasted
glassed93710433_glassed
grassed93812793_grassed
harassed1237113harassed
hearsed113811403he_arsed
jessed144112303je__ssed
leased74722883le_a_sed
leashed113211163le_ashed
legalised1145843legalised
legated92513983lega_ted
massed94421323__massed
measled10339303me_asled
megass9219443megass__
messed95018183me__ssed
negated93413233nega_ted
orgasmed1242933orgasmed
outgassed1145623outgassed
passed94320943__passed
recessed1139713recessed
regained102111243regained
regaled93615963rega_led
regarded11279803regarded
regauged1135143regauged
reglossed1144003reglossed
regressed1138113regressed
rehashed1536063rehashed
relapsed1136523relapsed
repasses101810373repasses
repasted112611533repasted
reraised9312353reraised
retasted92412113retasted
rewashed1546243rewashed
sassed76116173__sassed
teargassed1252153teargassed
teased74721153te_a_sed
yeasted1138503ye_asted
yessed104511163ye__ssed

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 Filter1786911461620.1531167915.0
2DLD Change Limit1461621576.75321644.0
3Display Results1571570.0602616.7
 (SQL Overall)1786911576.96625651.9
 
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.