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

213 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
breathing1521837(None) 
breaching17269401breaching
breathings16234311breathings
wreathing16266311wreathing
bathing134816242b__athing
beaching164114142b_eaching
beating104326872b_eat_ing
berating113220762berat_ing
berthing14209592b_erthing
bleaching17287092bleaching
bleating113514502bleat_ing
breading123515462brea_ding
breaking153914252brea_king
breaming133612512brea_ming
breasting1239582breasting
breathier1435382breathier
breathily1744062breathily
breeching17236472breeching
broaching17287662broaching
creating113921952creat_ing
inbreathing1742802inbreathing
preaching172811162preaching
reaching143317202_reaching
sheathing1636872sheathing
treating92519612treat_ing
wrathing15248922wr_athing
abreacting1544533abreacting
aerating92821003aerat_ing
baching156017753b__aching
bashing135422583b__ashing
batching163712093b__atching
bating95132253b__at_ing
batting104422273b__atting
batwing13509813b__atwing
beading113221863b_ea_ding
beaming123618803b_ea_ming
beaning103820683b_ea_ning
bearding124011943b_earding
bearing103624773b_ea_ring
beatings114113233b_eat_ings
beetling1139283b_eetling
belching16349153b_elching
belting104119133b_elt_ing
benching163411343b_enching
bequeathing2651573bequeathing
beraking153612973bera_king
bereaving1537573berea_ving
besting104923923b_est_ing
betaking153010153b_etaking
bethink1677203b_e_think
betting103921403b_e_tting
birthing14338433b_irthing
blatting114111653b_latting
blearing113111943blea_ring
blenching17276503blenching
bloating113512813bloat_ing
boating103721303b_oat_ing
borating113414503borat_ing
bracing123817613br_a_cing
bradding13268933br_adding
bragging13359333br_agging
braiding123112703br_aiding
brailing113514793br_ailing
braining113414683br_aining
braising113014563br_aising
braking143917713br_a_king
branching17289263branching
branding122513683br_anding
branning112911093br_anning
brassing112612303br_assing
brattling1236003brattling
braving133714613br_a_ving
bravoing1445993br_avoing
brawling143210043br_awling
braying134416313br_a_ying
brazing193715113br_a_zing
breadline1246273breadline
breakings16297063brea_kings
breastpin1342593breastpin_
breastpins1442713breastpins
breath113916263breath___
breathe123711843breath__e
breathed14469643breath_ed
breather133610593breath_er
breathers14319103breathers
breathes134212903breath_es
breathiest1545993breathiest
breathiness1644323breathiness
breaths124411183breath__s
breathtaking2271613breathtaking
breathy15328033breath__y
breechings18273723breechings
breeding123411843bre_eding
breezing20368133bre_ezing
breveting1536263breveting
brevetting1644333brevetting
brewing133411153bre__wing
bristling1246663bristling
brittling1235543brittling
bromating1439163bromat_ing
bruiting11259973bruit_ing
brunching17316483brunching
brushing14359963br_ushing
bruting102612993br_ut_ing
cheating144014523cheat_ing
cleating113518133cleat_ing
crashing143512633cr_ashing
crating103725203cr_at_ing
creaking153414123crea_king
creaming133413143crea_ming
creasing113314443crea_sing
creatin93618133creat_in_
creatine103417413creat_ine
creatins103617513creat_ins
creeshing1536243creeshing
cremating14312193cremat_ing
cresting114017043crest_ing
deashing134210953_deashing
derating103222283derat_ing
deratting1139513deratting
dratting10389653dr_atting
dreading113712803drea_ding
dreaming124011063drea_ming
drenching16256033drenching
earthing12310323__earthing
eating75134403__eat_ing
enwreathing1842123enwreathing
erecting112415063erect_ing
freaking163611453frea_king
frenching18267753frenching
freshing152611023fre_shing
fretting122711523fre_tting
frothing15208533fr_othing
graphing1538533gr_aphing
grating93923183gr_at_ing
greasing102811393grea_sing
greatening1245443greatening
greeting103112353greet_ing
heating114024323_heat_ing
ideating10311703ideat_ing
inearthing1443543inearthing
lathing114315693__lathing
leaching143012833_leaching
leashing123310313_leashing
loathing1247673_loathing
naething1236073nae_thing
nonbreathing1852103nonbreathing
orating83520323or_at_ing
peaching163613643_peaching
pleaching17257083pleaching
pleating112916053pleat_ing
prating103424453pr_at_ing
preacting142412533preacting
prearming14139223prearming
predating13514653predat_ing
pretaping1439133pretaping
prettying1536043prettying
prewashing1944943prewashing
rating74938703_r_at_ing
ratting83822363_r_atting
reacting113317893_reacting
readding11411363_readding
reading93327213_rea_ding
readying13410223_readying
reaming103924013_rea_ming
reaping103621213_rea_ping
rearing83128783_rea_ring
rearming111413613_rearming
reaving113820533_rea_ving
rebating112418343_rebat_ing
redating102620173_redat_ing
rehashing1647113_rehashing
relating92725443_relat_ing
rematching1844913_rematching
remating112322413_remat_ing
renting84026853_rent_ing
repatching1844993_repatching
resting85031183_rest_ing
restring91518783_restring
retaking133114283_retaking
retaping113012553_retaping
retaxing162311333_retaxing
retching143412173_retching
rethink1488883_re_think
retting83425883_re_tting
retying113213833_re_tying
rewashing1676903_rewashing
roaching143210433_roaching
scathing14269703_scathing
seating84130683_seat_ing
seething1239023_seething
sheathings1743913sheathings
sleuthing1334203sleuthing
swathing15248713_swathing
sweating123213023sweat_ing
teaching143612603_teaching
teething1237163_teething
threating131010043threat_ing
trashing122613223tr_ashing
treading103515333trea_ding
treadling1137503treadling
trenching15227653trenching
trithing122811773tr_ithing
trothing122410843tr_othing
unearthing1454373unearthing
unwreathing1842803unwreathing
upreaching1844113upreaching
wreaking163010213wrea_king
wreathen14256143wreathen_
wrenching18276273wrenching
wresting123811833wrest_ing
wrestling1336063wrestling
writhing15278673wr_ithing

Search took 8 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.1561145455.1
2DLD Change Limit1486412137.36020195.8
3Display Results2132130.0932290.3
 (SQL Overall)1786912137.60923484.2
 
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.