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

140 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
subduers118636(None) 
subduer10107031subduer_
subdues1099891subdue_s
subdebs1236482subd_ebs
subduals1156292subduals
subduces1397262subduces
subducts13106092subducts
subdue9128492subdue__
subdued11107112subdue_d
subers85722642sub__ers
sudsers83310422su_dsers
sunders84120052sund_ers
bubblers11448943bubblers
budders113812103bu_dders
budgers114314923bu_dgers
bundlers11399183bundlers
cubers105318353cub__ers
cuddlers12388383cuddlers
curdlers11368493curdlers
dubbers124011823dub_bers
funders113813933fund_ers
guiders94111113guid_ers
huddlers13337633huddlers
hurdlers12337493hurdlers
judders16347793ju_dders
judgers16369043ju_dgers
lubbers113913723lub_bers
mudders113211113mu_dders
muddlers12428813muddlers
murders103311363murd_ers
nudgers9479373nu_dgers
outdoers937513outdoers
outduels945053outduels
puddlers12298683puddlers
pursuers10376523pursuers
queuers16366393qu_euers
rubbers113913193rub_bers
rudders93210653ru_dders
sabers85224733sab__ers
saddlers10289753saddlers
sanders84025943sand_ers
seders74420283s_ed_ers
seducers1145383s_educers
seeders83017113seed_ers
senders83022353send_ers
shaders115915553shad_ers
shedders13267433shedders
shudders13316643shudders
siddurs934173siddu_rs
sidlers83414233s_idlers
skidders1454823skidders
sledders10257373sledders
sliders83515223slid_ers
slubbers12349943slub_bers
snubbers12326673snub_bers
sobbers114114263sob_bers
sobers85218863sob__ers
solders83517773sold_ers
soldiers9277773soldiers
sonders83820713sond_ers
sounders93214113sound_ers
spaders104214473spad_ers
spiders103914413spid_ers
spudders12255633spudders
studiers9236623studiers
subadars11125093subadars
subadults1273193subadults
subareas1038623subareas
subclerk1643793subclerk
subclerks1742853subclerks
subcults1246933subcults
subcutes1238583subcutes
subcutis1246293subcutis
subdealers1344113subdealers
subdean1037403subd_ean
subdeans1137203subdeans
subdeb1137523subd_e_b
subdual10126713subdu_al
subduce12106983subdu_ce
subduced14105163subduced
subduct12107583subdu_ct
subduedly1692723subduedly
subduing1235823subduing
subdural1145883subdural
subdwarf1743383subdwarf
subdwarfs1841713subdwarfs
suber74924503sub__er_
subfuscs1543753subfuscs
subgums1235893subgu_ms
subideas1146443subideas
subitems1245493subitems
sublets92616703sub_lets
sublimers1345773sublimers
submerse1237633sub_merse
subnets92512083sub_nets
suborders1245503suborders
suborners1146313suborners
subrules1039723subrules
subsere9311443sub_sere
subseres10312423sub_seres
subsets92813103sub_sets
subsiders1246053subsiders
subsumes1246923subsumes
subteens1037423subteens
subtler92910843subtler_
suburb1037163sub_u_rb
suburbs1136503sub_urbs
subvert12312893sub_vert
subverts1336973sub_verts
subzero1835613sub_zero
suckers133717623su_ckers
sucklers14379963sucklers
suddens9308783su_ddens
sudors7311103su_d_ors
sudser73511283su_dser_
sudses74114503su_dse_s
suedes73918113sued_e_s
suers55128483s___uers
suffers133113543su_ffers
sugarers936303sugarers
suiters73618883su_iters
sulfurs1037343sulfu_rs
sulkers113613343su_lkers
summers113616503su_mmers
sumpters1238023sumpters
sundaes8313093sundae_s
sunder74019823sund_er_
sunderers1039073sunderers
sundews11398153sund_ews
sundress936983sundress
supers84622403su__pers
suppers113314703su_ppers
surfers103614133su_rfers
surgers83517483su_rgers
sutlers73116973su_tlers
sutures7314223su_tures
tubbers113411253tub_bers
tubers85017033tub__ers
udders83911293_u_dders
undoers82910583_undoers

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621407.26620115.9
3Display Results1401400.0602333.3
 (SQL Overall)1786911407.74923059.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.