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

209 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
subdebs123648(None) 
subdeb1137521subdeb_
cubebs12508682cub_ebs
subdean1037402subdean
subdeans1137202subdeans
subduers1186362subduers
subdues1099892subdues
subers85722642sub_ers
subideas1146442subideas
sublets92616702sublets
subnets92512082subnets
subsets92813102subsets
suburbs1136502suburbs
suddens9308782suddens
suedes73918112suede_s
sunders84120062sunders
sundews11398152sundews
ardebs937013_ardebs
aubades1038753aubade_s
blebs96416153__blebs
bubkes144612623bubke_s
buboes104513993buboe_s
budders113812103budders
burdens1039713burdens
cobwebs1631933cobwebs
cubeb115814663cub_eb_
cubers105318353cub_ers
cubes95028163cub_e_s
debs76530243___debs
dubbers124011823dubbers
dudes75424373du_de_s
flubdubs1641513flubdubs
funders113813943funders
gudes74520813gu_de_s
guiders94111113guiders
guides84118283guide_s
guldens9356573guldens
hubbubs1342603hubbubs
jubes145420743jub_e_s
judders16347793judders
lubbers113913723lubbers
lubes74727993lub_e_s
ludes65728853lu_de_s
mudders113211113mudders
murders103311363murders
nudes64723293nu_de_s
pubes94423403pub_e_s
rubbers113913193rubbers
rubels84112993rub_els
rubes74928413rub_e_s
rubies84420343rubie_s
rubles83921703ruble_s
rudders93210653rudders
sabers85224733sab_ers
sabes76437463sab_e_s
sables85026693sable_s
sabres85520863sabre_s
saddens9309603saddens
sades65239893s_ade_s
sanders84025943sanders
seders74420283s_eders
seeders83017113seeders
seidels838393seidels
senders83022353senders
serdabs1035323serdabs
shaders115915553shaders
shades105924533shade_s
shudders13316643shudders
sibbs96211903sib__bs
sides65838373s_ide_s
sliders83515223sliders
slides73922183slide_s
slubbers12349943slubbers
snubbers12326673snubbers
snubness1044373snubness
sobbers114114263sobbers
sobers85218863sob_ers
soddens9348413soddens
solders83517773solders
sonders83820713sonders
sondes74922873sonde_s
sounders93214123sounders
spaders104214473spaders
spades94222583spade_s
spiders103914413spiders
spodes94817433spode_s
spudders12255633spudders
stades74626243stade_s
subadars11125103subadars
subahs114512393sub_ahs
subareas1038633subareas
subas74724083sub__as
subbass1138043subbass
subbed114116673subbe_d
subcell1146763subcell
subcells1246293subcells
subcodes1338143subcode_s
subdepot1344683subdepot
subdepots1443163subdepots
subdual10126723subdual
subduals1156303subduals
subduce12106983subduce
subduces1397263subduces
subduct12107583subduct
subducts13106093subducts
subdue9128493subd_ue
subdued11107113subdued
subduer10107043subduer
subedit1049403subedit
subedits1146723subedits
suber74924503sub_e_r
subgenus1145753subgenus
subgums1235893subgums
subhead1387693subhead
subheads1496533subheads
subidea1037533subide_a
subitems1245493subitems
subject18258633subject
subjects19226533subjects
sublease1038383sublease
sublet82827243suble_t
sublots92410913sublots
submenu1148363submenu
submenus1245903submenus
submerse1237633submerse
submiss1138083submiss
submits1139753submits
subnet82520933subne_t
suborders1245503suborders
suborns939493suborns
subpena1136683subpena
subpenas1246913subpenas
subrent9315083subrent
subrents10310303subrents
subs66037123su___bs
subsea82610203subse_a
subsect112611843subsect
subsects12267903subsects
subsense1046963subsense
subsere9311443subsere
subseres10312423subseres
subset83122583subse_t
subsiders1246053subsiders
subsides11410823subside_s
subteen938523subteen
subteens1037423subteens
subtend1037103subtend
subtends1136173subtends
subtest9513963subtest
subtests1037533subtests
subtext1647653subtext
subtexts1744903subtexts
suburb1037163suburb_
subvene1238493subvene
subvenes1339633subvenes
subvert12312893subvert
subverts1336973subverts
subways1536173subways
subzero1835613subzero
success1146403success
suckers133717623suckers
sucres84218893sucre_s
sudden83310833sudde_n
sudds75513593su_d_ds
sudors7311103su_dors
suds56135303su_d__s
sudsers83310423sudsers
sudses74114503su_dses
suede64419753suede__
sueded84014633suede_d
suers55128483su__ers
sues46247653su__e_s
suets55126103su__ets
suffers133113543suffers
suiters73618883suiters
suites63727403suite_s
suldans8299723suldans
sulkers113613343sulkers
sumless92611123sumless
summers113616503summers
sundaes8313093sundaes
sundeck1445273sundeck
sundecks1544253sundecks
sunder74019833sunde_r
sundew10369693sunde_w
sundogs947103sundogs
sundress936983sundress
sunkets113511283sunkets
sunless73013693sunless
sunsets72911573sunsets
supers84622403su_pers
supes75628303su_pe_s
suppers113314703suppers
surds65624663surd__s
surfers103614133surfers
surgers83517483surgers
surges73924593surge_s
surreys10489443surreys
surveys13357573surveys
susses64221053susse_s
sutlers73116973sutlers
suttees74114063suttees
swedes102711893swede_s
syboes1139343syboe_s
syndets1136113syndets
tubbers113411253tubbers
tubers85017033tub_ers
tubes74826453tub_e_s
udders83911293_udders

Search took 9 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 Filter1786911340270.406440125.6
2DLD Change Limit1340272097.78017227.1
3Display Results2092090.1561339.7
 (SQL Overall)1786912098.34221420.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.