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_
tamburs11288601tamburs
ambers104519562_ambers
amours83512642_amours
cambers134017432cambers
gambirs12359072gambirs
hamburg1544122hamburg
hamburgs1643462hamburgs
iambus10468892iambu_s
lambers113817102lambers
sabers85224732sa_bers
sabirs85414622sa_birs
sacbuts1166472sacbuts
sagbuts1065222sagbuts
sambals115213482sambals
sambar103914162sambar_
sambas104219262samb_as
sambhars1544832sambhars
sambhur1453082sambhur_
sambos104315192samb_os
sambuca1344342sambuca
sambucas1444162sambucas
sambuke1544202sambuke
sambukes1644192sambukes
sandburs11105622sandburs
santurs7310762santurs
sapours93610612sapours
savours10389332savours
tambours1255862tambours
tambur10358712tambur_
tambura11326462tambura
tamburas12316042tamburas
abuts75417073_a_buts
albums10198273_albums
ambari103012153_ambari
ambaris113112123_ambaris
ambary134010533_ambary
ambeers11428923_ambeers
amber94523203_amber_
ambery133811123_ambery
ambits103713393_ambits
amblers115213563_amblers
ambles105121853_ambles
ambos95321243_amb_os
ambry123512093_amb_ry
ambush1336103_ambush
ameers84015573_ameers
amirs75924913_am_irs
amour75014853_amour_
ampuls1098893_ampuls
amus65529613_am_u_s
arbors84717873_arbors
arbours93910033_arbours
armours9389843armours
auburn836213_auburn
auburns935573_auburns
augurs7399963_augurs
babuls105413643ba_buls
babus95620333ba_bu_s
bamboos1348753bamboos
barbers114317503barbers
barbuts11439843barbuts
bombers134512593bombers
burs65847423___burs
cabers105023903ca_bers
camber124418473camber_
cambiums1644923cambiums
campers134220283campers
campus125213923campu_s
chambers173410613chambers
clambers144211283clambers
clamours1255963clamours
combers134516613combers
cumbers134515393cumbers
dabbers123813213dabbers
damars93814993dam_ars
dammars12308193dammars
dammers123214273dammers
damners104112113damners
dampers123915693dampers
darbars10510093darbars
daubers104610423daubers
demurs939773dem_urs
earbuds1044633earbuds
embars103812873_embars
embers104116173_embers
enamours1044653enamours
famous11412393famou_s
favours13437083favours
femurs1136713fem_urs
gabbers124612833gabbers
gambas115817513gamb_as
gambes116318313gamb_es
gambias125010723gambias
gambiers13337073gambiers
gambir11509753gambir_
gambits12399713gambits
gamblers13369733gamblers
gambles124016203gambles
gambols1238593gambols
gambs105721123gamb__s
gamers94420823gam_ers
gammers123214563gammers
gamuts958783gam_uts
gaurs66317993ga__urs
glamours1184723glamours
habus106317143ha_bu_s
hagbuts1354923hagbuts
hamauls12387803hamauls
hammers144216053hammers
hampers143616943hampers
harbors12412413harbors
harbours1346903harbours
homburg1543073homburg
homburgs1642733homburgs
humbugs1534243humbugs
humours1286413humours
iambics13425623iambics
iambs95815053iamb__s
iambuses1235783iambuses
imbues1037963_imbues
jabbers183610583jabbers
jambes175914053jamb_es
jambs166014623jamb__s
jammers183710703jammers
kabars124513953ka_bars
kombus1435523kombu_s
labors84016403la_bors
labours9349883labours
lambdas1246243lambdas
lamber104418493lamber_
lambert113617113lambert
lamberts12348783lamberts
lambies113015103lambies
lambs95921413lamb__s
lampers113817333lampers
langurs889103langurs
lemurs837253lem_urs
limbers113614723limbers
limbus105710373limbu_s
lumbars11289763lumbars
lumbers113815913lumbers
mambas125716243mamb_as
mamboes135011823mamboes
mambos125414493mamb_os
mamluks1543313mamluks
mammers104615693mammers
mamzers20409163mamzers
members13258603members
mimbars1397373mimbars
nabbers113710463nabbers
namers84517333nam_ers
nimbus10377273nimbu_s
numbers113711243numbers
ombers104214393_ombers
pampers133615933pampers
ramblas112710263ramblas
ramblers124010373ramblers
rambles113118313rambles
rammers113715043rammers
ramous8417103ramou_s
ramus76418283ram_u_s
rumours976363rumours
sabals84618863sa_bals
sabbats1138633sabbats
saber75330243sa_ber_
sabes76437463sa_b_es
sabins85521973sa_bins
sabir75916993sa_bir_
sables85026693sa_bles
sabots8314693sa_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
sailers73822313sailers
sailors73213713sailors
sajous13310583sajou_s
sakers104125433sa_kers
salters73622253salters
salvers103916003salvers
salvors103910903salvors
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
samurais1046133sam_urais
sandbars11108783sandbars
sandbur10105353sandbur_
sandburr11123223sandburr
sandburrs12112783sandburrs
sanders84025943sanders
sangars83116253sangars
sangers84421943sangers
sannups934463sannups
sansars73313913sansars
santirs7312963santirs
santours837173santours
santur6311273santur_
sapors84118813sa_pors
sapour83812373sapour_
sappers113518893sappers
sardars83112903sardars
sarsars73512143sarsars
sartors7314953sartors
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
scaurs85512043s_caurs
scours84913583s_cours
seamers94719433seam_ers
sebums10369813s_ebums
shambles15159043shambles
shammers153710833shammers
shamus114112813sham_u_s
shmears1277073shmears
siddurs934173siddurs
sieurs659043s_ieurs
simars84916933sim_ars
simmers113314613simmers
simpers113014113simpers
sjamboks2342233sjamboks
slabbers123610123slabbers
slammers123511223slammers
slumbers123110273slumbers
slurs54123373s__lurs
smears84714433s_mears
smuts75415713s_m_uts
sobbers114114253sobbers
sobers85218853s_obers
somber103713993somber_
sombre10729473somb_re
sours55230503s__ours
spambots1443313spambots
spammers14378693spammers
spurs74621523s__purs
stabbers12268723stabbers
stammers123611523stammers
stampers124211593stampers
starburst1143493starburst
stours65015623s_tours
subers85722643s_ubers
suburb1037163s_uburb
suburbs1136503s_uburbs
sulfurs1037343sulfurs
summers113616503summers
sunburn945133sunburn
sunburns1044273sunburns
sunburst1045183sunburst
swabbers15316743swabbers
swampers15317473swampers
symbols1435523symbols
tabers84621573ta_bers
tabors84517093ta_bors
tabours94110073tabours
tabuns8489223ta_buns
tabus74820923ta_bu_s
tambacs13219363tambacs
tambaks15218153tambaks
tambour1136343tambour_
tamboura1253883tamboura
tambouras1343473tambouras
tamers84224033tam_ers
tampers113516743tampers
timbers113111833timbers
tumours976733tumours
umbers104215203_umbers
valours10248733valours
vampers143111623vampers
vapours12277453vapours
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.1561145455.1
2DLD Change Limit1340273256.65620136.3
3Display Results3253250.1102954.5
 (SQL Overall)1786913256.92225814.9
 
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.