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

294 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
subdeb113752(None) 
subdebs1236481subdebs
cubeb115814662cub_eb
subbed114116672subbed
subdean1037402subdean
subdue9128492subdue
subdued11107112subdued
subduer10107032subduer
subdues1099882subdues
suber74924502sub_er
subidea1037532subidea
sublet82827242sublet
subnet82520932subnet
subsea82610192subsea
subset83122582subset
suburb1037162suburb
sudden83310832sudden
suede64419752suede_
sueded84014632sueded
suedes73918112suedes
sunder74019822sunder
sundew10369692sundew
ardeb8314523_ardeb
asunder856223asunder
aubade939223aubade_
aubades1038743aubades
aulder7511453aulder
bleb85425223__bleb
bubkes144612623bubkes
buboed113010003buboed
buboes104513993buboes
budded113912333budded
budder104314813budder
burden9412473burden
cobweb1533243cobweb
cube85830213cub_e_
cubebs12508683cub_ebs
cubed105519703cub_ed
cuber95222533cub_er
cubes95028163cub_es
curded104217163curded
deb66342693___deb
dubbed124113213dubbed
dubber113814553dubber
dude65629663du_de_
duded84417133du_ded
dudes75424373du_des
flubdub1541703flubdub
fubbed144711243fubbed
funded114413893funded
funder104016083funder
gude65423333gu_de_
gudes74520813gu_des
guide75019883guide_
guided94014113guided
guider84313523guider
guides84118283guides
gulden8328763gulden
hubbub1243603hubbub
jube136322783jub_e_
jubes145420743jub_es
judder15439423judder
lubber104214623lubber
lube64731563lub_e_
lubed85319893lub_ed
lubes74727993lub_es
lude55331643lu_de_
ludes65728853lu_des
mudded114511383mudded
mudder104413493mudder
murder93613783murder
nude56626273nu_de_
nuder66416833nu_der
nudes64723293nu_des
pubes94423403pub_es
rubbed114515083rubbed
rubber104715793rubber
rube65532013rub_e_
rubel75416833rub_el
rubes74928413rub_es
rubied94312413rubied
rubier84814743rubier
rubies84420343rubies
ruble74521253ruble_
rubles83921703rubles
rudder83812803rudder
rude55632783ru_de_
ruder65320543ru_der
sabbed114518083sabbed
sabe66140573sab_e_
sabed86526813sab_ed
saber75330243sab_er
sabes76437463sab_es
sable74732163sable_
sables85026693sables
sabre74821503sabre_
sabred95916533sabred
sabres85520863sabres
sadden83212403sadden
sadder82916973sadder
sade55544473s_ade_
sades65239893s_ades
sanded84920613sanded
sander74828533sander
scubaed1236123scubaed
scudded12215933scudded
seder64826753s_eder
seeded84520463seeded
seeder74320773seeder
seidel7311083seidel
sended85121233sended
sender73824413sender
serdab937833serdab
shade95125583shade_
shaded114518873shaded
shader104218763shader
shades105924533shades
shudder12297323shudder
sibb85921423sib__b
side55444483s_ide_
sided74825953s_ided
sides65838363s_ides
slide64725413slide_
slider73918363slider
slides73922183slides
slubbed12339283slubbed
slubber113010763slubber
snide64318723snide_
snider74413913snider
snubbed12347443snubbed
snubber11277733snubber
sobbed113516263sobbed
sobber104016583sobber
sober74822403sob_er
sodded94113303sodded
sodden84011513sodden
solder73921343solder
sonde64622833sonde_
sonder73623523sonder
sondes74922873sondes
sounded93214463sounded
sounder83315383sounder
spade84423323spade_
spaded103816753spaded
spader94317133spader
spades94222583spades
spider94516803spider
spode84617703spode_
spodes94817433spodes
spudded12235903spudded
spudder11256553spudder
stade64825303stade_
stades74626243stades
stubbed12378083stubbed
studded10236873studded
suable83920553suable_
suave83519873suave_
suaver93014233suaver
sub55445553su___b
suba64926603sub__a
subadar10125573subadar
subah106015213sub_ah
subahs114512383subahs
subarea939403subarea
subas74724073sub_as
subcell1146743subcell
subcode1237163subcode_
subcodes1338133subcodes
subdeans1137203subdeans
subdepot1344683subdepot
subdual10126713subdual
subduce12106983subduce
subduced14105163subduced
subduces1397263subduces
subduct12107583subduct
subduers1186353subduers
subedit1049403subedit
subers85722643subers
subfix1835073subfix
subgum1136133subgum
subhead1387693subhead
subideas1146443subideas
subindex1843453subindex
subitem1138543subitem
subito8410453subito
subject18258633subject
sublets92616703sublets
sublot82315523sublot
submenu1148363submenu
submit10312673submit
subnets92512083subnets
suborder1146663suborder
suborn8310003suborn
subpar1048663subpar
subpena1136673subpena
subrent9315083subrent
subs66037123sub__s
subsect112611843subsect
subsere9311443subsere
subsets92813103subsets
subside10410453subside_
subsided1257643subsided
subsider1138243subsider
subsides11410823subsides
subteen938523subteen
subtend1037103subtend
subtest9513963subtest
subtext1647653subtext
subtle82113433subtle
subtler92910843subtler
subtly11249263subtly
suburbs1136503suburbs
subvene1238493subvene
subvert12312893subvert
subway1447073subway
subzero1835613subzero
sucked134120493sucked
sucker124120663sucker
sucre75019103sucre_
sucres84218893sucres
sudd64719773su_d_d
suddens9308783suddens
sudds75513593su_dds
sudor6312623su_dor
suds56135293su_d_s
sudsed83911373sudsed
sudser73511283sudser
sudses74114503sudses
sudsy95010683su_dsy
sue35651463su__e_
sued56537933su__ed
suer45334033su__er
sues46247653su__es
suet46754823su__et
suffer124314513suffer
sughed113610203sughed
suite54829563suite_
suited74019423suited
suiter64121813suiter
suites63727403suites
suldan72611043suldan
sulked114314703sulked
sulker104015923sulker
sullen62914293sullen
summed114014043summed
summer104017713summer
sundae7312873sundae
sundaes8313093sundaes
sundeck1445273sundeck
sunders84120053sunders
sundews11398153sundews
sundog837613sundog
sundry1057943sundry
sunken103511783sunken
sunket103721363sunket
sunned74216323sunned
sunset63723633sunset
supe65932763su_pe_
super74924483su_per
superb104410993superb
supes75628303su_pes
supped114415703supped
supper104115433supper
surd56433813surd__
surds65624663surd_s
sure45447413su_re_
surer54833093su_rer
surfed103814463surfed
surfer93515883surfer
surge65027693surge_
surged84118883surged
surger74320093surger
surges73924593surges
surrey94414573surrey
survey124111663survey
sussed75015533sussed
susses64221053susses
sutler63718393sutler
suttee63721543suttee
swede94413203swede_
swedes102711893swedes
syboes1139343syboes
syndet10311963syndet
tubae74716643tubae_
tubbed114712223tubbed
tubber104313203tubber
tube65828663tub_e_
tubed85818043tub_ed
tuber75420683tub_er
tubes74826453tub_es
udder76314283_udder
unde55825483_unde_
undee65327273_undee
under64624213_under

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162945.23621527.1
3Display Results2942940.0933161.3
 (SQL Overall)1786912945.46932673.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.