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

126 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
dribbling153371(None) 
dibbling14247331d_ibbling
drabbling1544551drabbling
dribbing14325881dribb_ing
fribbling1733671fribbling
brabbling1334962brabbling
cribbing15276842cribb_ing
dabbling14227972d_abbling
dibbing133110892d_ibb_ing
drabbing14286802drabb_ing
drilling103311982dri_lling
driveling1445762driveling
drizzling1943022drizzling
drubbing14286052drubb_ing
drumbling1544032drumbling
grabbling1564582grabbling
kibbling17225702_kibbling
nibbling13256502_nibbling
quibbling2342822quibbling
rabbling13239332_rabbling
ribbing123111952_ribb_ing
rubbling13238072_rubbling
scribbling1742552scribbling
babbling12228693_babbling
bibbing11299613_bibb_ing
bobbling12238643_bobbling
brambling1635543brambling
bribing123111043bri_b_ing
bridling122610583bri_dling
brisling112410843bri_sling
bristling1246663bristling
brittling1235543brittling
bubbling12248223_bubbling
cobbling15248803_cobbling
crabbing15287933crabb_ing
cribbings16273173cribb_ings
crimpling1645343crimpling
crinkling16145863crinkling
crippling1644093crippling
crumbling1655083crumbling
dabbing133511233d_abb_ing
dabblings15193883d_abblings
dialing94318173d_i_aling
dialling10310783d_ialling
diddling12228743d_iddling
dimpling14199023d_impling
dindling112411163d_indling
dirling93316073d_i_rling
disabling1337753disabling
doubling1238153d_oubling
draggling1354613draggling
drawling13318673dr_awling
dribble12368603dribbl__e
dribbled14376593dribbl_ed
dribbler13316313dribbl_er
dribblers14274453dribblers
dribbles13348393dribbl_es
dribblet13347543dribbl_et
dribblets14294143dribblets
dribbly15274953dribbl__y
drifting13338733dri_fting
drillings11285823dri_llings
drinking14308913dri_nking
dripping14278033dri_pping
driveline1345353driveline
drivelling1543983drivelling
driving123910713dri__ving
drolling103510763dr_olling
drooling102610423dr_ooling
drubbings15262883drubb_ings
dubbing133311213d_ubb_ing
dwindling15123793dwindling
fibbing15339463_fibb_ing
frilling123011493fri_lling
frivoling1644493frivoling
frizzling2153113frizzling
gabbling14238073_gabbling
gibbing13339373_gibb_ing
gobbling14257533_gobbling
grabbing14267313grabb_ing
griddling1333933griddling
grilling103811533gri_lling
grizzling1942843grizzling
grubbing14295403grubb_ing
grumbling1544083grumbling
hobbling16227583_hobbling
jibbing19338063_jibb_ing
libeling1139873_libeling
nibbing12339553_nibb_ing
nobbling13228273_nobbling
pebbling1535073_pebbling
prickling1836533prickling
prilling113413413pri_lling
rambling131810773_rambling
ribbings13275923_ribb_ings
ribboning1443513_ribboning
riddling11249443_riddling
ridgling11258203_ridgling
riesling939013_riesling
riffling1556113_riffling
rifling112815013_ri_fling
riling74227973_ri__ling
rilling84023623_ri_lling
rimpling13219663_rimpling
rippling13197573_rippling
rivaling1239913_rivaling
robbing123313213_robb_ing
rubbing123412273_rubb_ing
rumbling131910103_rumbling
scabbling1634863scabbling
scrabbling1742853scrabbling
sibling10814423_si_bling
snibbing13295893snibb_ing
trebling1139873tr_ebling
trembling1435193trembling
trickling1647723trickling
trifling122411503tri_fling
trilling92815963tri_lling
trindling1137133trindling
tripling112712553tri_pling
troubling1234943troubling
wabbling16207743_wabbling
wimbling16186543_wimbling
wobbling16246923_wobbling
wriggling1533813wriggling
wrinkling17144953wrinkling

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.420425454.8
2DLD Change Limit1486411267.29620372.9
3Display Results1261260.0632000.0
 (SQL Overall)1786911267.77922970.9
 
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.