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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
drownding156412(None) 
drowning13298361drown_ing
browning14299642brown_ing
crowding15247932crow_ding
crowning143510032crown_ing
downing123811672d_own_ing
droning93013722dro_n_ing
drowsing13287772drow_sing
frowning15307832frown_ing
grounding1236082grounding
rounding102812282_rounding
abounding1335193abounding
arointing1049363arointing
aroynting1344633aroynting
bonding113318433_bo_nding
bounding123012133_bounding
branding122513683br_anding
brocading1556253brocading
bronzing2037693bro_nzing
brooding122911373bro_oding
browsing14319353brow_sing
clowning14307253clown_ing
crooning113112113croon_ing
crowing133814763crow__ing
dawning124111013d_awn_ing
decrowning1743593decrown_ing
defending15298353defending
defunding15216123defunding
demanding14237923demanding
depending14208783depending
desanding12207653desanding
disowning1446113disown_ing
donning93512763d_o_nning
doweling13279763d_oweling
dowering132510613d_owering
dowing114221513d_ow__ing
downlink1644523d_ownlink
downswing1743043d_ownswing
downwind1653413d_ownwind
dowsing123411123d_ow_sing
draining103312673drain_ing
drawing123812053draw__ing
drawling13318673draw_ling
dreading113712803dr_eading
drinking14308913dr_inking
drolling103510763dro_lling
drooling102610423dro_oling
drooping12268803dro_oping
dropping14309283dro_pping
drouking1436443dro_uking
droving12379683dro__ving
drownd11478313drownd___
drownded14334433drownd_ed
drownds12346153drownd__s
eroding9314273ero__ding
fonding123815423_fo_nding
founding133010793_founding
friending1495553friending
fronting12310443fro_nting
frouncing1534763frouncing
frowsting1634683frowsting
gowning12258833_gown_ing
grinding1139863gr_inding
groaning102410283groan_ing
groining102310633groin_ing
groundings1343743groundings
groundling1343393groundling
growing123512473grow__ing
growling1348163grow_ling
hounding132610053_hounding
ironing82414013iro_n_ing
mounding123311263_mounding
owning104110333__own_ing
poinding122510003_poinding
ponding114317083_po_nding
pounding123311473_pounding
prawning1446963prawn_ing
prodding13189343pro_dding
pronging123511843pro_nging
propending1646143propending
protending1446813protending
providing1637963providing
prowling1449993prow_ling
rending93924263_r_ending
rewinding14238933_rewinding
rodding103814533_ro_dding
roweling122811123_roweling
rowing103623303_row__ing
sounding102712873_sounding
stounding1136233stounding
swounding1434133swounding
trending103012833tr_ending
trouncing1235153trouncing
troweling1376363troweling
trowing113413703trow__ing
unrounding1244873unrounding
wounding13249403_wounding
wronging13327393wro_nging

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.440406115.9
2DLD Change Limit148641987.23320550.4
3Display Results98980.0462130.4
 (SQL Overall)178691987.71923149.5
 
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.