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 “auding” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

143 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
auding8361693(None) 
adding93914961adding
aiding84423611aiding
audings9289391audings
duding93913321duding
lauding93211901lauding
aahing1019015762aahing
abiding11510502abiding
aboding11410122aboding
abusing1049112abusing
abying124410412abying
aching126521972aching
acing87429152a_cing
acting95920982acting
addling10229832addling
adzing174110012adzing
aedine73218392aedine
ageing84213402ageing
aging77026352a_ging
ahing98928352a_hing
ailing74331012ailing
aiming94320842aiming
airing74927502airing
alluding1036952alluding
amping114317572amping
amusing1039382amusing
anting75827022anting
aping87327232a_ping
arcing95819642arcing
arming94719802arming
ashing107824092ashing
asking116017232asking
audial7312992audial
audient8312302audient
audile73315302audile
audio62917102audi_o
audios72312282audios
audit62527882audi_t
auditing1039032auditing
audits72814112audits
autoing8314042autoing
auxin121411912auxin_
auxins13129812auxins
aweing103911252aweing
awing96827322a_wing
awning105013392awning
axing138521372a_xing
balding114015062balding
banding114921412banding
barding113822892barding
biding104720792biding
boding104320062boding
budding123712402budding
budging124313022budging
busing96420592busing
buying124213832buying
carding113922442carding
causing103614412causing
ceding104014802ceding
coding104024792coding
cubing114213952cubing
cueing94913612cueing
cuing85420192cu_ing
curding113515132curding
curing94824782curing
daubing11358622daubing
dauting93814762dauting
ding66940952__ding
duking124715132duking
duping104113632duping
during84419402during
eluding93412112eluding
ending83220252ending
exuding16347442exuding
fading114821112fading
farding123716742farding
feuding123410262feuding
fudging133310012fudging
fuming124013292fuming
funding124113662funding
fusing104415952fusing
fuzing194110642fuzing
gadding113411452gadding
gauging10339962gauging
gauming11319712gauming
guiding102911842guiding
guying11379722guying
hading113922942hading
handing123518892handing
hauling113714432hauling
hiding114319332hiding
jading154214022jading
jauking19418322jauking
jauping17307192jauping
judging17337932judging
juking183810472juking
lading84227122lading
landing92819322landing
larding92917872larding
lubing94114042lubing
luging83915292luging
luring73820752luring
luting75221752luting
madding123711992madding
mauling103315682mauling
mudding123310812mudding
muling93519882muling
muring95120372muring
musing93919502musing
muting93921522muting
niding83217982niding
nudging10328692nudging
nuking113411252nuking
outing74128152outing
padding123412512padding
pausing103912812pausing
pudding124010802pudding
puking133913062puking
puling93621402puling
radding103715002radding
raiding93617592raiding
reding83825562reding
riding84325962riding
ruing67221052ru_ing
ruling73219552ruling
sanding93520602sanding
saucing10311002saucing
siding83822132siding
sudsing92910322sudsing
sueding92613752sueding
suing65026362su_ing
tauting83316382tauting
tiding83520092tiding
tubing93813092tubing
tuning74016842tuning
using66317962_using
wadding133711942wadding
wading114619532wading
warding123918142warding
wauking153410012wauking
wauling112713112wauling
yarding123413142yarding
yauping13357242yauping

Search took 3 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 Filter178691825510.346516448.0
2DLD Change Limit825511432.46633475.7
3Display Results1431430.0463108.7
 (SQL Overall)1786911432.85862523.1
 
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.