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

119 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
bathing13481624(None) 
baching156017751baching
bashing135422581bashing
batching163712091batching
bating95132251bat_ing
batting104422271batting
batwing13509811batwing
lathing114315691lathing
aahing1019015762_aahing
abashing1466622abashing
abating10413972abat_ing
aching126521972_aching
ahing98928352_a_hing
ashing107824092_ashing
baaing94916162ba_aing
babying1537962babying
backing165523442backing
badging123712792badging
baffing164011602baffing
bagging123316982bagging
bailing103723522bailing
baiting103918882baiting
baking135626622ba_king
balding114015062balding
baling94829692ba_ling
balking143717352balking
balling104424762balling
bamming144611812bamming
banding114921412banding
banging114019862banging
baning95127832ba_ning
banking144621352banking
banning103818232banning
bantling112612002bantling
barbing123716992barbing
barding113822892barding
barfing134615092barfing
barging114018482barging
baring95135852ba_ring
barking144724182barking
barning104320352barning
barring104021592barring
bashings144311242bashings
basing95427662ba_sing
basking144718612basking
basting104227202basting
batiking1537502batiking
battings114010572battings
battling113110492battling
bawling133813862bawling
baying125222582ba_ying
beaching164114142beaching
beating104326872beat_ing
berthing14209602berthing
bethink1677202bethink
betting103921402betting
birthing14338432birthing
bitching163610622bitching
biting95321822bit_ing
bitting103717292bitting
blatting114111652blatting
boating103721302boat_ing
botching16359702botching
breathing15218372breathing
bushing134018582bushing
butling103516812butling
butting103519282butting
caching156317502caching
cashing135022552cashing
catching163712772catching
catling104819792catling
catting103922642catting
dashing125917892dashing
dating85326482dat_ing
earthing12310332earthing
eating75134402eat_ing
faithing1537152faithing
farthing1538072farthing
fashing144918792fashing
fating105328672fat_ing
fatling113815682fatling
fatting113818702fatting
gashing125119232gashing
gating84826952gat_ing
hashing145020162hashing
hatching173312212hatching
hating104929712hat_ing
hatting113920232hatting
kithing153411552kithing
kything18285522kything
lashing114422892lashing
latching143712022latching
lathings12469852lathings
loathing1247672loathing
mashing134422242mashing
matching163512392matching
mating94832912mat_ing
matting103620142matting
naething1236072naething
nothing113511902nothing
pashing135120512pashing
patching163212752patching
patting103722342patting
pithing134014052pithing
rating74938702rat_ing
ratting83822362ratting
sashing114621472sashing
sating74735452sat_ing
scathing14269702scathing
swathing15248712swathing
tatting84019522tatting
thing96622982__thing
tithing113513892tithing
tything14316572tything
vatting113614852vatting
washing145119282washing
watching173011172watching
withing143814492withing
wrathing15248922wrathing

Search took 4 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 Filter1786911076710.373479064.3
2DLD Change Limit1076711192.93636672.7
3Display Results1191190.0502380.0
 (SQL Overall)1786911193.35953197.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.