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

140 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
degauss93392(None) 
degames113312622degames
degamis11268442degamis
degas75119162dega__s
degases93413102degases
degasses10278362degasses
degaussed1242542degaussed
degausser1172162degausser
degausses1143202degausses
degums10438622deg_ums
degust8310252deg_ust
degusts936062deg_usts
gauss65613452__gauss
megass9219442mega_ss
bagass938933baga_ss
beaus75127113be_au_s
beauts86015283be_auts
because1136233because
bedaubs1233693bedaubs
begalls10319163begalls
begazes1937963begazes
begums11429493beg_ums
belauds1036643belauds
daubs85014563d__aubs
dauts67822243d__auts
deads75726913de_a_ds
deairs74013783de_airs
deals65435343de_a_ls
deans66131393de_a_ns
dears65736883de_a_rs
deash95617243de_a_sh
deaths105914443de_aths
deaves105319533de_aves
debags104211063deba_gs
debarks14388493debarks
debars94218043deba_rs
debase94014473deba_se
debases103814133debases
debates103718533debates
debauch15134423debauch
debugs10467823de_bugs
debuts93911753de_buts
decades113615513decades
decafs124010883deca_fs
decals93717713deca_ls
decamps1435643decamps
decanes103118913decanes
decants103514443decants
decares102818533decares
decays124612913deca_ys
declass1038733declass
dedans85915073deda_ns
defaces133213403defaces
defames132812253defames
defangs1235363defangs
defats105114553defa_ts
default1147893default
defaults1243333defaults
defrauds1343243defrauds
defuse105712723de_fuse
defuses114814593de_fuses
degage92711383dega_ge
degame102713183dega_me
degami10279013dega_mi
degassed11275963degassed
degasser10325813degasser
degassers11354833degassers
degaussers1241663degaussers
degaussing1342293degaussing
degerms1135623degerms
deglazes1935463deglazes
degrades11269923degrades
degrees92810723degrees
degum94711903deg_u_m
dekares122710873dekares
delates83526283delates
delays104014053dela_ys
delouse839833delouse
delouses9310013delouses
demands114311413demands
demarks14339233demarks
demast9517063dema_st
demasts1089223demasts
demurs939773de_murs
denars74621433dena_rs
dengues938183dengues
departs104310683departs
depress10239873depress
derails84216393derails
derates84028893derates
derats74625063dera_ts
derays105514253dera_ys
desalts839573desalts
desands94810163desands
details84214043details
detains83716093detains
detours858043detours
devalues1235853devalues
devas96218883deva__s
devours1166643devours
dewans105215143dewa_ns
dewars105117073dewa_rs
dewaxes18297843dewaxes
dewless1137473dewless
digress938323digress
discuss10357953discuss
dugouts935043dugouts
egads74610923_ega_ds
egress73310433_egress
eyass84410783_eya_ss
gauds75717723__gauds
gaums86217073__gaums
gaurs66317993__gaurs
hegaris11310433hegaris
leagues837943leagues
legals73412733lega_ls
legates82917683legates
legatos82711183legatos
legless838013legless
megasse10266243megasse
megasses11307743megasses
negates83215843negates
negus64513563neg_u_s
neguses837933neg_uses
pegless1038053pegless
percuss1137163percuss
petasus946363petasus
regains84316583regains
regales83520793regales
regards94112563regards
regauge945813regauge
regauges1046093regauges
regius7311923regiu_s
regloss8218023regloss
reglues838713reglues
regress82711453regress
repass84114703repa_ss
segues7412073seg_ues
teguas768013teg_uas
vegans103910853vega_ns

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.406440125.6
2DLD Change Limit1340271406.44020811.6
3Display Results1401400.0463043.5
 (SQL Overall)1786911406.89225927.3
 
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.