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

145 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
blotching173496(None) 
botching16359701b_otching
batching163712092b_atching
bitching163610622b_itching
blanching17297092blanching
bleaching17287092bleaching
blenching17276502blenching
blocking174510572blo_cking
blotchier1643212blotchier
blotchily1942682blotchily
blotting113910432blot_ting
broaching17287662broaching
clothing14278782clot_hing
clutching17154822clutching
fletching18256142fletching
flitching18265342flitching
hotching17309312_hotching
latching143712022_latching
letching143810262_letching
notching14288582_notching
scotching1735652scotching
slouching15195722slouching
splotching1842862splotching
avouching1843273avouching
baching156017753b__aching
bathing134816243b_at_hing
beaching164114143b_eaching
beclothing1843873beclot_hing
belching16349153b_elching
benching163411343b_enching
berthing14209593bert_hing
bewitching2162773bewitching
birching16328463b_irching
birthing14338433birt_hing
blacking174213603bl_acking
blatting114111653blat_ting
blitzing2035903blit_zing
bloating113512813blo_ating
blobbing12246923blo_bbing
blogging13369013blo_gging
blooding122410653blo_oding
bloodying1643783bloodying
blooming13299433blo_oming
blooping13248843blo_oping
blotch13197143blotch___
blotched1635653blotch_ed
blotches1537433blotch_es
blotchiest1743523blotchiest
blotchy17293973blotch__y
blousing1138793blo_using
blowing133813053blo__wing
blowtorching236783blowtorching
blushing14339333bl_ushing
bolting104416763bolt__ing
booting103821363boot__ing
botchier15287143b_otchier
botchily1864373b_otchily
bottling11279143b_ottling
branching17289263branching
breaching17269403breaching
breeching17236473breeching
brunching17316483brunching
bunching163410703b_unching
catching163712773_catching
clenching17266303clenching
clinching17276123clinching
clocking174312413clo_cking
clothings15264433clot_hings
clotting113110643clot_ting
cloturing1245473cloturing
coaching164011963_coaching
couching163213263_couching
crouching1746383crouching
crutching17216073crutching
ditching15349943_ditching
douching15349843_douching
etching134511843__etching
fetching17298413_fetching
fleeching18305013fleeching
flenching18296703flenching
fletchings19282863fletchings
flinching18245833flinching
floccing16306033flo_ccing
flocking183410873flo_cking
frothing15208533frot_hing
glunching16174083glunching
grouching1644943grouching
grutching16224373grutching
hatching173312213_hatching
hitching173310523_hitching
hutching17318643_hutching
itching134011683__itching
kvetching2242903kvetching
lathing114315693_lat_hing
leaching143012833_leaching
leching134613653_l_eching
leeching14318373_leeching
loathing1247673_loathing
locking143718153_lo_cking
locoing102810973_lo_coing
lotting82917753_lot_ting
lunching143110003_lunching
lurching14277333_lurching
lynching17336083_lynching
matching163512393_matching
mooching16259063_mooching
mouching163110583_mouching
nothing113511903_not_hing
ouching134314903__ouching
patching163212753_patching
pitching163411113_pitching
pleaching17257083pleaching
plotting113011013plot_ting
plotzing20276153plot_zing
ploughing16203673ploughing
poaching163510833_poaching
pooching16328983_pooching
pouching163210413_pouching
retching143412173_retching
roaching143210433_roaching
scooching1735073scooching
scootching1843363scootching
scorching1735633scorching
scutching1735223scutching
sketching1935083sketching
sloshing12258823slo_shing
slotting92612613slot_ting
sloughing14244753sloughing
smooching1734883smooching
smutching1734853smutching
snatching1536363snatching
snitching1535913snitching
soothing12269973soot_hing
stitching1547103stitching
switching1835703switching
thatching1835143thatching
toothing12278863toot_hing
torching142510083_torching
touching143211343_touching
trothing122410843trot_hing
twitching1834243twitching
unlatching1643153unlatching
vouching17308233_vouching
watching173011173_watching
witching173410633_witching

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.1731032896.0
2DLD Change Limit1486411456.90621523.5
3Display Results1451450.0632301.6
 (SQL Overall)1786911457.14225019.7
 
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.