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

426 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
crumber1333964(None) 
clumber134011441clumber
crumbed14378471crumbed
crumbers14338221crumbers
crumbier1456361crumbier
cumber124016701c_umber
camber124418472c_amber
chamber164011052chamber
clamber133311732clamber
climber13449132climber
clubber13319592clubber
clumbers143910392clumbers
comber125118502c_omber
crabber133810732crabber
crambe1239072crambe_
crambes1339952crambes
crammer134010962crammer
cribber13367662cribber
crimmer133310772crimmer
crimper136510422crimper
cruder95612382cru_der
crueler939022crueler
cruiser93410432cruiser
cruller968752cruller
crumb114313592crumb__
crumble133410402crumble
crumbled15357442crumbled
crumbles14329682crumbles
crumblier1543872crumblier
crumbly16347522crumbly
crumbs12409232crumb_s
crumbum1543742crumbum
crumby15408112crumb_y
crummier1435602crummier
crumped144311222crumped
crumpet133711062crumpet
crupper13338562crupper
crusher124412322crusher
cuber95222532c_u_ber
cucumber1642602cucumber
cumbers134515392c_umbers
cummer124414592c_ummer
curber104517052c_urber
drubber12357862drubber
drummer12407502drummer
dumber114414172_dumber
grubber12417912grubber
grumbler13866682grumbler
grummer12338782grummer
lumber103817772_lumber
number103913222_number
plumber13339982plumber
rubber104715792_rubber
rumbler113514112_rumbler
rummer104715482_rummer
scrubber1434112scrubber
slumber113811002slumber
umber94617582__umber
amber94523203__amber
armer76924443ar_m_er
blubber10399293blubber
bomber125014653_bomber
briber104714043br_iber
brimmer13348803brimmer
bruiser9349573bruiser
bruiter93710633bruiter
brumbies1436533brumbies
brumby15385953brumb_y
brume95817983brum_e_
brumes106417073brum_es
brusher123813003brusher
brusker13437853brusker
bumbler134013233_bumbler
bummer124014103_bummer
bumper123714343_bumper
caber95126833c__aber
caliber1139733caliber
calmer105216933calm_er
cambers134017433c_ambers
camper124722213c_amper
caulker13456893caulker
causer84117783cau_ser
cerumen1147763cerum_en
chambers173410613chambers
chamfer17399853chamfer
champer163813403champer
chimer135517203chim_er
chomper163810073chomper
chromier1538033chromier
chubbier1733893chubbier
chudder14245943chudder
chuffer18337143chuffer
chugger1445373chugger
chukker1543833chukker
chummed17396443chummed
chummier1734513chummier
chumped17379493chumped
chunter123911473chunter
churner12298343churner
clabber134210113clabber
clambers144211283clambers
clammer134211793clammer
clamper134012993clamper
climbed14336983climbed
climbers14318403climbers
clobber13378163clobber
clubbed14307453clubbed
clubbers14378573clubbers
clubbier1434833clubbier
clubmen1334253clubmen
clumped143610663clumped
clumpier1435583clumpier
clumsier1234733clumsier
clunker13419453clunker
cluster94013323cluster
clutter94211653clutter
cobber124116843c_obber
combe116223543c_ombe_
combed135516543c_ombed
combers134516613c_ombers
combes125321733c_ombes
comember1644163comember
comer95832693c_om_er
coombe124110093coombe_
coombes133810663coombes
coruler9311713coru_ler
corymbed1842613corymbed
coucher144515853coucher
cougher133711733cougher
coulter94115593coulter
counter94220143counter
coupler114713013coupler
courier93617873courier
courser94114803courser
courter94516463courter
couter84930203cou_ter
couther123914623couther
crabbed14388873crabbed
crabbers14358743crabbers
crabbier14326803crabbier
cracker153114173cracker
cradler102910503cradler
crafter124111333crafter
crambo1238043cramb_o
cramboes1436543cramboes
crambos1336783crambos
crammed143710123crammed
crammers14369343crammers
cramped144712183cramped
crampier14288903crampier
cranker133612783cranker
crapper133913193crapper
crasher124616153crasher
crasser94114333crasser
crater85026633cr_ater
craver114618463cr_aver
crawler123510453crawler
crazier183610743crazier
creamer113714083creamer
creamier12319063creamier
creaser94415723creaser
creeper11339973creeper
creme94319323crem_e_
cremes104517993crem_es
crepier1139733crepier
cribbed14407663cribbed
cribbers14306443cribbers
crier74724463cr__ier
crime94822693crim_e_
crimes105521583crim_es
crimmers14298543crimmers
crimped143910763crimped
crimpers14318933crimpers
crimpier14287323crimpier
cringer103514243cringer
crisper113511053crisper
critter94113033critter
croaker133010683croaker
crofter12299573crofter
crooker134111093crooker
crooner93714043crooner
cropper133312963cropper
crosier94116573crosier
crosser95015463crosser
croupier1246883croupier
crowbar1444253crowbar
crowder13389843crowder
crower114117553cr_ower
crowner124012593crowner
crozer175112843cr_ozer
crozier18369933crozier
cruces105117543cru_ces
crucifer1543683crucifer
crudded1235733crudded
cruddier1244153cruddier
crude86018573cru_de_
crudes96218623cru_des
cruel74815903cru__el
crueller1056453crueller
cruet74831843cru__et
cruise84314043cruise_
cruised103710213cruised
cruisers10438263cruisers
cruises93514443cruises
crullers1047293crullers
crumbiest1536253crumbiest
crumbing15267813crumbing
crumbums1642733crumbums
crumhorn1542883crumhorn
crummie1336153crummie
crummies1437643crummies
crummy15365893crum_my
crump115616423crum__p
crumpets14335943crumpets
crumple13368363crumple
crumpled15296873crumpled
crumples14348813crumples
crumplier1543783crumplier
crumply16336093crumply
crumps124514343crum_ps
cruncher15338073cruncher
cruor7310443cru__or
cruppers14317313cruppers
crusader1144263crusader
cruse75726103cru_se_
cruses88127713cru_ses
cruset84425093cru_set
crushed134111963crushed
crushers134010083crushers
crushes124215133crushes
crusted103712753crusted
crustier10259533crustier
cruxes154911563cru_xes
cube85830213c_u_be_
cubeb115814653c_u_beb
cubed105519703c_u_bed
cubers105318343c_u_bers
cubes95028163c_u_bes
cucumbers1742483cucumbers
cudbear1233333c_udbear
culler84322253c_uller
culver113010633c_ulver
cumbered15157953c_umbered
cumberer14266993c_umberer
cumbia12379883c_umbia
cummers133713473c_ummers
cunner83915003c_unner
cupper124313863c_upper
curbed114615873c_urbed
curbers115514373c_urbers
curdier103312613curdier
curdler103511563curdler
curer75030753c_u_rer
curler85221323c_urler
curlier93314183curlier
currier93316693currier
curser84721473c_urser
curter85320073c_urter
curvier123110663curvier
cusser86016093c_usser
cuter74728223c_u_ter
cutler84718033c_utler
cutter84520993c_utter
cyber124910383c__yber
dauber94112013dau_ber
drabber12438593drabber
drubbed13406983drubbed
drubbers13386023drubbers
drudger10328323drudger
drumbeat1343973drumbeat
drumble12337893drumble
drumbled14266033drumbled
drumbles13277723drumbles
drumlier1134523drumlier
drummed13306323drummed
drummers13316163drummers
drunker12326633drunker
dubber113814553_dubber
dumbed124012083_dumbed
dumper114615213_dumper
ember95516793__ember
encumber1454143encumber
flubber14287713flubber
framer114817443fram_er
fruiter10309683fruiter
frumpier1534173frumpier
fumbler143610813_fumbler
fumer105918233_fum_er
fumier11310903_fumier
glummer12417983glummer
grabber12389763grabber
grimier103210433grimier
grimmer123510093grimmer
grubbed13406433grubbed
grubbers13316193grubbers
grubbier13344753grubbier
grudger10368313grudger
grueler837023grueler
gruffer1475793gruffer
grumble12349233grumble
grumbled14256753grumbled
grumblers14245023grumblers
grumbles13288873grumbles
grumbly15355403grumbly
grume86218163grum_e_
grumes94415553grum_es
grummet12298873grummet
grumped13337333grumped
grumpier1334803grumpier
grunger9389783grunger
grunter83110783grunter
gummer114615453_gummer
humbler143411943_humbler
hummer133615273_hummer
humper134115883_humper
incumber1444543incumber
jumbler183910273_jumbler
jumper173612373_jumper
krimmer15376873krimmer
kruller1145153kruller
lamber104418493_lamber
limber104316773_limber
lubber104214623_lubber
lumbar103610593_lumbar
lumbers113815913_lumbers
lumper103816653_lumper
member12258853_member
mumbler133510913_mumbler
mummer93614543_mummer
mumper123513523_mumper
numbed114111443_numbed
numbers113711243_numbers
omber95316433__omber
ormer75218373or_m_er
plumbed14317273plumbed
plumbers14418513plumbers
plumbery17315533plumbery
plumier113510043plumier
plummer13298523plummer
plumper13318773plumper
premier113515633premier
prenumber1543163prenumber
primer105118683prim_er
primmer134310163primmer
prober104516073pr_ober
pruner83413453pru_ner
pumper124415553_pumper
rambler113313263_rambler
rammer103519653_rammer
renumber1244243renumber
ribber103515493_ribber
rimer75429243_rim_er
rimier83916263_rimier
rimmer103516033_rimmer
robber103916533_robber
romper104213683_romper
rubbed114515083_rubbed
rubbers113913183_rubbers
rubbery14337593_rubbery
rube65532013_ru_be_
rubel75416833_ru_bel
rubes74928413_ru_bes
rubier84814733_rubier
rudder83812803_rudder
ruder65320543_ru_der
ruer46127563_ru__er
rugger84414513_rugger
ruiner64013643_ruiner
ruler54923343_ru_ler
rulier65016353_rulier
rumba93612513_rumb_a
rumbaed12287493_rumbaed
rumbas102512013_rumbas
rumble103718813_rumble
rumbled124514593_rumbled
rumblers123610743_rumblers
rumbles114018393_rumbles
rumbly134412163_rumbly
rumen74419503_rum_en
rummers113513653_rummers
rummier11309563_rummier
rumor71011323_rum_or
rumour8127373_rumour
runner63814463_runner
rusher94019653_rusher
scrambler15165043scrambler
scriber113910963scr_iber
scrimper1455753scrimper
scrubbed1533853scrubbed
scrubbers1543363scrubbers
scrubbier1543333scrubbier
scrummed1554313scrummed
scummer13398753scummer
slubber113010763slubber
slumbers123110273slumbers
slumbery15296043slumbery
slummer113711203slummer
snubber11277733snubber
somber103713993_somber
spumier1137903spumier
strummer1234783strummer
stumbler1235813stumbler
stumper113610093stumper
suber74924503_su_ber
summer104017713_summer
thrummer1542933thrummer
thumbed15336173thumbed
thumper14356953thumper
timber104012673_timber
tramper113812153tramper
trembler1235363trembler
trimer85717153trim_er
trimmer113610833trimmer
trucker134010733trucker
trudger9338723trudger
truer54916643tru__er
trumped12439713trumped
trumpery1533613trumpery
trumpet113810723trumpet
trusser74010253trusser
truster73114313truster
tubber104313203_tubber
tuber75420683_tu_ber
tumbler113412823_tumbler
umbel93612833__umbel
umbers104215203__umbers

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340274267.28018410.3
3Display Results4264260.1562730.8
 (SQL Overall)1786914267.59223536.7
 
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.