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

218 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
drubbing1428605(None) 
drabbing14286801drabbing
dribbing14325881dribbing
drubbings15262881drubbings
dubbing133311211d_ubbing
grubbing14295401grubbing
rubbing123412271_rubbing
blubbing12257012blubbing
clubbing15266512clubbing
crabbing15287932crabbing
cribbing15276842cribbing
crumbing15267812crumbing
dabbing133511232d_abbing
daubing11358622dau_bing
dibbing133110892d_ibbing
doubling1238152doubling
doubting1237372doubting
drabbling1544552drabbling
dribbling1533712dribbling
drudging12256232drudging
drugging12326442drugging
drumbling1544032drumbling
drumming14265782drumming
dubbin11329262d_ubbin_
dubbings14245472d_ubbings
dubbins12358802d_ubbins
dumbing13319852d_umbing
flubbing16275882flubbing
fubbing15409572_fubbing
grabbing14267312grabbing
ribbing123111952_ribbing
robbing123313212_robbing
rubbings13306332_rubbings
rubbling13238072_rubbling
rubying13297932_rubying
scrubbing1633932scrubbing
slubbing13248032slubbing
snubbing13236672snubbing
stubbing13237452stubbing
subbing123915582_subbing
tubbing123510092_tubbing
bibbing11299613_bibbing
blabbing12266723blabbing
blebbing12265673blebbing
blobbing12246923blobbing
blurbing13326503blurbing
bobbing113113193_bobbing
brabbling1334963brabbling
bribing123111043br_ibing
bruising11279143bruising
bruiting11259973bruiting
brushing14359963brushing
bruting102612993bru_ting
bruxing17236823bru_xing
bubbling12248223_bubbling
burbling13249423burbling
cabbing143613153_cabbing
cribbings16273173cribbings
crudding1335723crudding
cruising112610153cruising
crumbling1655083crumbling
crumping15319903crumping
crushing143010053crushing
crusting113612793crusting
cubing114213953_cu_bing
curbing123814023_curbing
dabbling14227973dabbling
daunting103310403daunting
dauting93814763dau_ting
debuting12268633debuting
demobbing1743493demobbing
deucing1139393deu_cing
dibbling14247333dibbling
dobbin11339523d_obbin_
dobbins12379533d_obbins
douching15349843douching
dousing93315763dou_sing
drafting13339403drafting
dragging12308103dragging
draining103312673draining
dramming14347563dramming
draping114213353dr_aping
dratting10389653dratting
drawing123812053dr_awing
drawling13318673drawling
draying123813843dr_aying
dreading113712803dreading
dreaming124011063dreaming
dredging12236423dredging
dreeing94311183dr_eeing
dressing102810423dressing
drifting13338733drifting
drilling103311983drilling
drinking14308913drinking
dripping14278033dripping
driving123910713dr_iving
drolling103510763drolling
droning93013723dr_oning
drooling102610423drooling
drooping12268803drooping
dropping14309283dropping
drouking1436443drouking
droving12379683dr_oving
drowning13298363drowning
drowsing13287773drowsing
drubbed13406983drubb_ed
drubber12357863drubb_er
drubbers13386033drubbers
drumlin1044423drumlin_
drumlins1144993drumlins
drying113411603dr__ying
ducking154315053d_ucking
ducting113713593d_ucting
duding93913323d_u_ding
dueling93614543d_ueling
dueting93814393d_ueting
duking124715133d_u_king
dulling93418273d_ulling
dumping133712913d_umping
dunging103012623d_unging
dunking133813263d_unking
dunning93514473d_unning
dunting93418383d_unting
duping104113633d_u_ping
dupping133711043d_upping
during84419403d_u_ring
durning93511733d_urning
dusking133912053d_usking
dusting93618993d_usting
ebbing1137073__ebbing
eructing112110173eructing
erupting11218443erupting
fibbing15339463_fibbing
fobbing153410273_fobbing
fribbling1733673fribbling
frugging14317053frugging
fruiting12229063fruiting
gabbing133512033_gabbing
gibbing13339373_gibbing
gobbing132910703_gobbing
grabbling1564583grabbling
grubbier13344753grubbier
grubbily1642973grubbily
grudging12255993grudging
grueling1078273grueling
gruffing1635273gruffing
grumbling1544083grumbling
grumping14266903grumping
grunting10269583grunting
hobbing152811123_hobbing
jabbing19319413_jabbing
jibbing19338063_jibbing
jobbing19279013_jobbing
lobbing123110913_lobbing
lubing94114043_lu_bing
mobbing14299703_mobbing
nabbing12299963_nabbing
nibbing12339553_nibbing
nubbin10308293_nubbin_
nubbins11268023_nubbins
numbing12269033_numbing
orbing93312363or__bing
plumbing15286433plumbing
probing123314443pr_obing
pruning10311733pru_ning
rabbin103112303_rabbin_
rabbins112811343_rabbins
rabbling13239333_rabbling
redubbing1543573redubbing
ribbings13275923_ribbings
robbin103611183_robbin_
robbins112811063_robbins
robing93618003_r_obing
rubbering1435703_rubbering
rubbies114114113_rubbies
rubbish1436303_rubbish
ruching133612933_ruching
rucking143216673_rucking
ruffing143210843_ruffing
rugging102512763_rugging
ruing67221053_ru__ing
ruining83514883_ruining
ruling73219553_ru_ling
rumbaing13185303_rumbaing
rumbling131910103_rumbling
running83514593_running
rushing113817703_rushing
rusting83821263_rusting
rutting82718043_rutting
sabbing123314743_sabbing
scabbing15277193scabbing
scubaing1335733scubaing
slabbing13287783slabbing
slubbings14213383slubbings
snibbing13295893snibbing
sobbing127612883_sobbing
squibbing2342753squibbing
stabbing13238763stabbing
stobbing13227243stobbing
subbings13238483_subbings
subring104116263_subring
swabbing16246453swabbing
swobbing16235173swobbing
tabbing123611913_tabbing
throbbing1743533throbbing
thumbing16245513thumbing
trebling1139873trebling
troubling1234943troubling
trucing103211843tru_cing
trucking153310163trucking
trudging11266443trudging
trueing83410183tru_eing
truing73913933tru__ing
trumping13308733trumping
trussing9268653trussing
trusting93411653trusting
tubing93813093_tu_bing
webbing1536123_webbing

Search took 7 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 Filter1786911461620.423422437.4
2DLD Change Limit1461622186.17023689.1
3Display Results2182180.0962270.8
 (SQL Overall)1786912186.68926714.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.