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

137 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
degerming143575(None) 
deperming1537111deperming
decerning1337292decerning
deeming113913122de_e_ming
deferring1436142deferring
deforming1636702deforming
degumming1643132degumming
demerging1436642demerging
deserting11713142deserting
deserving1497902deserving
deterging1237852deterging
determine1249032determine
deterring1138622deterring
deworming1635042deworming
adeeming1254793ade_e_ming
angering102113803anger_ing
begetting13186583begetting
begirding1434333begirding
begriming1545533begriming
berming123614833__berming
beseeming1435143beseeming
beworming1734553beworming
daggering13246113dagger_ing
dangering12239303danger_ing
deaerating12311563deaerating
deairing10311893deair_ing
debarking1735383debarking
debarring1335713debarring
debeaking1735923debeaking
debearding1543733debearding
deceasing1338403deceasing
deceiving1635733deceiving
decreeing1335523decreeing
decrying15237413de_crying
decurving1634723decurving
deeding103315123de_e_ding
defaming15238463de_faming
defeating142311973defeating
defecting162510223defecting
defencing16226693defencing
defending15298353defending
defensing14217003defensing
deferment151210303deferment
defoaming1645653defoaming
deforcing1636063deforcing
degassing1234823degassing
degerm1037893degerm___
degermed1335453degerm_ed
degerms1135623degerm__s
deglazing2135133deglazing
degrading13137373degrading
degreasing1345423degreasing
degusting1236163degusting
dehorning1455243dehorning
dehorting1447213dehorting
dejecting20217793dejecting
dekeing13358353deke__ing
deleading1237773deleading
deleaving1436263deleaving
deleing93313953dele__ing
deleting103314423dele_ting
deliming12310373de_liming
demarking1736773demarking
demeaning1337243demeaning
dementing13311043dementing
demeriting1448683demeriting
demurring1335253demurring
departing1349513departing
depending14208783depending
depluming1544713depluming
deporting1369593deporting
descrying1635103descrying
deservings1593663deservings
desexing1736293dese_xing
desiring10312143desir_ing
desorbing1346363desorbing
detecting13259983detecting
determent121312903determent
determined1455823determined
determiner1345483determiner
determines1358433determines
determining1545293determining
detesting112610323detesting
deveining1436393deveining
develing133212733deve_ling
devesting14249903devesting
digesting12208673digesting
disarming1338803disarming
diverging15226693diverging
diverting142410333diverting
dogearing1235763dogearing
dowering132510613dower_ing
dreaming124011063d_reaming
egesting1039013_egesting
emerging1237893_emerging
everting122213133_everting
exerting162211153_exerting
fevering152510083fever_ing
gemming13289153__gemming
germina1038503__germina
gorming112810833__gorming
jeering153513043je_er_ing
lagering102212313lager_ing
leering83417643le_er_ing
levering122212503lever_ing
metering112915633meter_ing
nevermind1543303nevermind
peering103520353pe_er_ing
perming123416093__perming
petering112516813peter_ing
rearming111413613re_arming
redeeming1337363redeeming
referring1338033referring
reforming1538563reforming
regarding12149153regarding
regearing112211413regearing
regorging1236823regorging
rehemming1734743rehemming
remerging1358323remerging
reperking1638703reperking
reserving131110643reserving
reteaming122110443reteaming
reverbing15248593reverbing
revering122918073rever_ing
reversing132611483reversing
reverting132315133reverting
rewarming15147383rewarming
rezeroing1935933rezeroing
rogering10310273roger_ing
secerning1246203secerning
seeming103216263se_e_ming
severing122013853sever_ing
sewering122411093sewer_ing
teeming103513093te_e_ming
terming104016003__terming
veering113213683ve_er_ing
wagering13219523wager_ing

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411377.56319653.7
3Display Results1371370.0632174.6
 (SQL Overall)1786911378.04922200.4
 
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.