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

131 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
degassing123482(None) 
degaussing1342291degaussing
deashing134210952de_ashing
debasing12238062deba_sing
declassing1445122declassing
degusting1236162degusting
demasting1338452demasting
gassing94216332__gassing
repassing12249422repassing
amassing1138003_amassing
begalling13216493begalling
begazing2136633bega_zing
bekissing1643503bekissing
biassing11307263_biassing
brassing112612303_brassing
bypassing1742953bypassing
ceasing104118263ce_a_sing
cessing103814813ce__ssing
classing113211793_classing
crevassing1643533crevassing
damasking1744603damasking
dashing125917893d__ashing
deairing10311893de_airing
dealing94323233de_a_ling
deaning94020473de_a_ning
deaving123814753de_a_ving
debagging1533593debagging
debarking1735383debarking
debarring1335713debarring
debating123213733deba_ting
decamping1734943decamping
decanting132510633decanting
decaying15239453deca_ying
deceasing1338403deceasing
defacing15238683defa_cing
defaming15238463defa_ming
defanging1535333defanging
defatting1436103defatting
defensing14217003defensing
defusing13227933de_fusing
degassed11275963degass_ed
degasser10325813degass_er
degassers11354833degassers
degasses10278363degass_es
degerming1435753degerming
deglazing2135133deglazing
degrading13137373degrading
degreasing1345423degreasing
degumming1643133degumming
dehiscing1643733dehiscing
delating103119603dela_ting
delaying133210973dela_ying
delisting112710503delisting
delousing1136303delousing
demanding14237923demanding
demarking1736773demarking
demising122012523de_mising
departing1349513departing
deposing12129773de_posing
depressing1448093depressing
derailing112011313derailing
deranging1238063deranging
derating103222283dera_ting
deratting1139513deratting
desalting1138843desalting
desanding12207653desanding
desisting112810383desisting
despising13167503despising
detaching1637263detaching
detailing112510413detailing
detaining112510473detaining
detasseling1362203detasseling
detesting112610323detesting
devaluing1434833devaluing
devesting14249903devesting
devising133111523de_vising
dewaxing20215293dewa_xing
digesting12208673digesting
digressing1345793digressing
dissing94517683d__issing
dossing93313273d__ossing
dressing102810423d_ressing
easing74926463_e_a_sing
easting84924303_e_asting
egesting1039013_egesting
egressing1146853_egressing
elapsing1146713_elapsing
erasing8317963_era_sing
feasing113916653fe_a_sing
feasting122011323fe_asting
fessing113812863fe__ssing
gashing125119233__gashing
gasking134415913__gasking
gasping113714363__gasping
gassings10438403__gassings
gasting95022763__gasting
glassing10329973_glassing
grassing103311973_grassing
harassing1346983harassing
hearsing1239383he_arsing
jessing153710623je__ssing
leashing123310313le_ashing
leasing83920163le_a_sing
legalising1245743legalising
legating102313113lega_ting
massing104318023__massing
messing103916393me__ssing
negating102012833nega_ting
orgasming1343113orgasming
outgassing1245353outgassing
passing104318423__passing
reassign955423re_assign
recasting122414233recasting
recessing12611013recessing
regaining112411083regaining
regaling10315363rega_ling
regarding12149153regarding
regauging1235543regauging
reglossing1244163reglossing
regressing1248143regressing
rehashing1647113rehashing
relapsing1236843relapsing
repasting122312843repasting
reraising10313773reraising
retasting102513413retasting
rewashing1676903rewashing
sassing84615553__sassing
teargassing1352003teargassing
teasing83918513te_a_sing
yeasting12188923ye_asting
yessing113210063ye__ssing

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411316.42323142.0
3Display Results1311310.0632079.4
 (SQL Overall)1786911316.90625874.7
 
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.