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

325 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
samburs1136934(None) 
sambars115113841sambars
sambhurs1543181sambhurs
sambur10469501sambur_
tamburs11288611tamburs
ambers104519582_ambers
amours83512662_amours
cambers134017442cambers
gambirs12359082gambirs
hamburg1544122hamburg
hamburgs1643472hamburgs
iambus10468902iambu_s
lambers113817112lambers
sabers85224732sa_bers
sabirs85414632sa_birs
sacbuts1166472sacbuts
sagbuts1065222sagbuts
sambals115213482sambals
sambar103914162sambar_
sambas104219262samb_as
sambhars1544832sambhars
sambhur1453082sambhur_
sambos104315192samb_os
sambuca1344342sambuca
sambucas1444162sambucas
sambuke1544202sambuke
sambukes1644192sambukes
sandburs11105622sandburs
santurs7310762santurs
sapours93610622sapours
savours10389342savours
tambours1255872tambours
tambur10358712tambur_
tambura11326462tambura
tamburas12316052tamburas
abuts75417073_a_buts
albums10198273_albums
ambari103012173_ambari
ambaris113112163_ambaris
ambary134010543_ambary
ambeers11428923_ambeers
amber94523213_amber_
ambery133811133_ambery
ambits103713413_ambits
amblers115213563_amblers
ambles105121863_ambles
ambos95321253_amb_os
ambry123512103_amb_ry
ambush1336113_ambush
ameers84015573_ameers
amirs75924923_am_irs
amour75014853_amour_
ampuls1098893_ampuls
amus65529613_am_u_s
arbors84717883_arbors
arbours93910043_arbours
armours9389853armours
auburn836213_auburn
auburns935573_auburns
augurs7399963_augurs
babuls105413643ba_buls
babus95620333ba_bu_s
bamboos1348753bamboos
barbers114317503barbers
barbuts11439843barbuts
bombers134512593bombers
burs65847423___burs
cabers105023923ca_bers
camber124418483camber_
cambiums1644933cambiums
campers134220293campers
campus125213923campu_s
chambers173410623chambers
clambers144211293clambers
clamours1255993clamours
combers134516623combers
cumbers134515413cumbers
dabbers123813213dabbers
damars93814993dam_ars
dammars12308193dammars
dammers123214273dammers
damners104112113damners
dampers123915693dampers
darbars10510093darbars
daubers104610423daubers
demurs939773dem_urs
earbuds1044633earbuds
embars103812883_embars
embers104116183_embers
enamours1044663enamours
famous11412393famou_s
favours13437093favours
femurs1136713fem_urs
gabbers124612833gabbers
gambas115817513gamb_as
gambes116318313gamb_es
gambias125010733gambias
gambiers13337073gambiers
gambir11509773gambir_
gambits12399723gambits
gamblers13369733gamblers
gambles124016203gambles
gambols1238593gambols
gambs105721123gamb__s
gamers94420833gam_ers
gammers123214563gammers
gamuts958783gam_uts
gaurs66317993ga__urs
glamours1184733glamours
habus106317143ha_bu_s
hagbuts1354933hagbuts
hamauls12387813hamauls
hammers144216063hammers
hampers143616953hampers
harbors12412413harbors
harbours1346923harbours
homburg1543073homburg
homburgs1642733homburgs
humbugs1534243humbugs
humours1286433humours
iambics13425643iambics
iambs95815063iamb__s
iambuses1235783iambuses
imbues1037983_imbues
jabbers183610583jabbers
jambes175914053jamb_es
jambs166014623jamb__s
jammers183710703jammers
kabars124513953ka_bars
kombus1435523kombu_s
labors84016413la_bors
labours9349893labours
lambdas1246243lambdas
lamber104418493lamber_
lambert113617113lambert
lamberts12348793lamberts
lambies113015113lambies
lambs95921413lamb__s
lampers113817333lampers
langurs889103langurs
lemurs837253lem_urs
limbers113614743limbers
limbus105710383limbu_s
lumbars11289763lumbars
lumbers113815913lumbers
mambas125716243mamb_as
mamboes135011823mamboes
mambos125414493mamb_os
mamluks1543313mamluks
mammers104615693mammers
mamzers20409163mamzers
members13258603members
mimbars1397383mimbars
nabbers113710463nabbers
namers84517333nam_ers
nimbus10377283nimbu_s
numbers113711243numbers
ombers104214403_ombers
pampers133615933pampers
ramblas112710263ramblas
ramblers124010373ramblers
rambles113118313rambles
rammers113715043rammers
ramous8417113ramou_s
ramus76418283ram_u_s
rumours976373rumours
sabals84618863sa_bals
sabbats1138633sabbats
saber75330243sa_ber_
sabes76437463sa_b_es
sabins85521983sa_bins
sabir75917003sa_bir_
sables85026693sa_bles
sabots8314703sa_bots
sabra75317853sa_b_ra
sabras85116363sa_bras
sabre74821503sa_b_re
sabres85520863sa_bres
sabs66643743sa_b__s
sacbut10811943sacbu_t
sackbuts1644053sackbuts
sackers133820223sackers
sacques18106863sacques
sacrums11388043sacrums
sadhus10298463sadhu_s
sagbut959753sagbu_t
saggars93610683saggars
saggers94017083saggers
sailers73822323sailers
sailors73213723sailors
sajous13310583sajou_s
sakers104125433sa_kers
salters73622253salters
salvers103916003salvers
salvors103910913salvors
samara8313853sam_ara
samaras9312913samaras
samba95618773samb__a
sambaed1238303sambaed
sambal105215183samb_al
sambhar1444853sambhar
sambo95118013samb__o
samechs14285353samechs
samekhs16303923samekhs
sameks12409323sam_eks
samiels939763samiels
samites93118713samites
samlets93813553samlets
samosas939293samosas
samovars1343703samovars
sampans112411003sampans
samplers12299403samplers
samples112815453samples
samps96124673sam__ps
samsara936913samsara
samsaras1045873samsaras
samshus12125353samshus
samurai945923sam_urai
samurais1046143sam_urais
sandbars11108783sandbars
sandbur10105353sandbur_
sandburr11123223sandburr
sandburrs12112783sandburrs
sanders84025943sanders
sangars83116253sangars
sangers84421943sangers
sannups934463sannups
sansars73313913sansars
santirs7312963santirs
santours837183santours
santur6311273santur_
sapors84118813sa_pors
sapour83812373sapour_
sappers113518903sappers
sardars83112903sardars
sarsars73512143sarsars
sartors7314963sartors
satyrs937963sa_tyrs
saucers93712133saucers
saugers83914053saugers
sauls55128123sa__uls
saury84317223sa__ury
savers93825923sa_vers
saviors1058993saviors
saviours1154273saviours
savors95616103sa_vors
savour94110703savour_
savoury13365873savoury
sawbuck1843923sawbuck
sawbucks1943413sawbucks
sawers94620163sa_wers
sawyers13317533sawyers
sayers94221593sa_yers
scammers14339773scammers
scampers143611033scampers
scaurs85512053s_caurs
scours84913593s_cours
seamers94719433seam_ers
sebums10369813s_ebums
shambles15159043shambles
shammers153710843shammers
shamus114112813sham_u_s
shmears1277073shmears
siddurs934173siddurs
sieurs659043s_ieurs
simars84916933sim_ars
simmers113314613simmers
simpers113014123simpers
sjamboks2342233sjamboks
slabbers123610123slabbers
slammers123511223slammers
slumbers123110273slumbers
slurs54123373s__lurs
smears84714433s_mears
smuts75415713s_m_uts
sobbers114114263sobbers
sobers85218863s_obers
somber103714003somber_
sombre10729473somb_re
sours55230503s__ours
spambots1443313spambots
spammers14378693spammers
spurs74621523s__purs
stabbers12268733stabbers
stammers123611523stammers
stampers124211603stampers
starburst1143493starburst
stours65015633s_tours
subers85722643s_ubers
suburb1037163s_uburb
suburbs1136503s_uburbs
sulfurs1037343sulfurs
summers113616503summers
sunburn945133sunburn
sunburns1044283sunburns
sunburst1045183sunburst
swabbers15316743swabbers
swampers15317473swampers
symbols1435523symbols
tabers84621573ta_bers
tabors84517113ta_bors
tabours94110093tabours
tabuns8489223ta_buns
tabus74820923ta_bu_s
tambacs13219363tambacs
tambaks15218153tambaks
tambour1136353tambour_
tamboura1253893tamboura
tambouras1343493tambouras
tamers84224033tam_ers
tampers113516743tampers
timbers113111853timbers
tumours976753tumours
umbers104215213_umbers
valours10248743valours
vampers143111623vampers
vapours12277463vapours
wambles143714023wambles
wammus13426733wammu_s
wampums16314213wampums
wampus13499013wampu_s
wamus105514683wam_u_s
yabbers14389353yabbers
yammers143410323yammers
yamuns11336513yam_uns

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 Filter1786911340270.390458182.1
2DLD Change Limit1340273256.17321711.8
3Display Results3253250.1232642.3
 (SQL Overall)1786913256.68626726.1
 
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.