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

298 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
tamburs1128861(None) 
samburs11369341samburs
tambours1255871tambours
tambur10358711tambur_
tambura11326461tambura
tamburas12316051tamburas
ambers104519582_ambers
amours83512662_amours
cambers134017442cambers
gambirs12359082gambirs
hamburg1544122hamburg
hamburgs1643472hamburgs
iambus10468902iambu_s
lambers113817112lambers
sambars115113842sambars
sambhurs1543182sambhurs
sambur10469502sambur_
tabers84621572ta_bers
tabors84517112ta_bors
tabours94110092tabours
tabuns8489222ta_buns
tabus74820922ta_bu_s
tambacs13219362tambacs
tambaks15218152tambaks
tambour1136352tambour_
tamboura1253892tamboura
tambouras1343492tambouras
tamers84224032tam_ers
tampers113516742tampers
timbers113111852timbers
tumours976752tumours
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
hagbuts1354923hagbuts
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
sabers85224733sa_bers
sabirs85414633sa_birs
sacbuts1166473sacbuts
sagbuts1065223sagbuts
sambals115213483sambals
sambar103914163sambar_
sambas104219263samb_as
sambhars1544833sambhars
sambhur1453083sambhur_
sambos104315193samb_os
sambuca1344343sambuca
sambucas1444163sambucas
sambuke1544203sambuke
sambukes1644193sambukes
sandburs11105623sandburs
santurs7310763santurs
sapours93610623sapours
savours10389343savours
stabbers12268733stabbers
stammers123611523stammers
stampers124211603stampers
starburst1143493starburst
tabard9313333ta_bard
tabards10310383ta_bards
tabbies112913503tabbies
tabbis102910863ta_bbis
taber73825823ta_ber_
tabes76033923ta_b_es
tablas83716163ta_blas
tables84524883ta_bles
taboos83815423ta_boos
tabor75518393ta_bor_
tabour84011323tabour_
tabs66842983ta_b__s
tabu66328493ta_bu__
tabued94310403ta_bued
tabuli839363ta_buli
tabulis938833ta_bulis
tabun75914373ta_bu_n
tackers134319623tackers
taggers93514193taggers
tahrs85412333ta__hrs
tailers73720183tailers
tailors73212393tailors
takers103923743ta_kers
takeups1333403takeups
talars66021683ta_lars
talcums1135513talcums
talers64628143ta_lers
talkers113513213talkers
taluks10418283ta_luks
talus55423263ta_lu_s
tamales93216153tamales
tamals84116633tam_als
tamari8313403tam_ari
tamaris9413593tamaris
tambac122210243tamb_ac
tambak14249263tamb_ak
tambala1138023tambala
tambalas1237033tambalas
tamboured1443783tamboured
tambourer1343493tambourer
tambourers1442743tambourers
tambourin1363613tambourin
tambourins1443473tambourins
tameins9311413tameins
tamer75230103tam_er_
tames75242013tam__es
tamis76728733tam__is
tamises92715973tamises
tammies113814683tammies
tampans113310983tampans
tamper104618513tamper_
tampons112711553tampons
tamps95524083tam__ps
tams67247933tam___s
tanbark1337373tanbark
tanbarks1445563tanbarks
tankers113416913tankers
tanners74018393tanners
tapers84025813ta_pers
tapirs84113173ta_pirs
tappers113416543tappers
tarbush1234173tarbush
tars46763953ta___rs
tarsus6310513tarsu_s
tartars73313403tartars
taskbars1452993taskbars
tasters74225643tasters
tatars64619793ta_tars
taters64932203ta_ters
tatters74520483tatters
taus46342733ta__u_s
tauts56125513ta__uts
tawers94118603ta_wers
taxers134015283ta_xers
taxus125512483ta_xu_s
temblors1244463temblors
tempers113513013tempers
tempura11295253tempura
tempuras12295063tempuras
tenours72610073tenours
tilbury1242983tilbury
timbals11239533timbals
timber104012683timber_
timbery14256893timbery
timbre10328633timb_re
timbres11249353timbres
timers84420993tim_ers
tombacs13248443tombacs
tombaks15246863tombaks
tomboys1435713tomboys
tombs97818733tomb__s
tours55325883t__ours
tramcars1245233tramcars
trampers123210393trampers
tubbers113411253tubbers
tubers85017033t_ubers
tumblers123110623tumblers
tumbles113816023tumbles
tumors8810613tum_ors
tumour8137403tumour_
tussurs7356393tussurs
tymbals14265723tymbals
umbers104215213_umbers
valours10248743valours
vampers143111623vampers
vapours12277463vapours
wambles143714023wambles
wammus13426733wammu_s
wampums16314213wampums
wampus13499013wampu_s
wamus105514683wam_u_s
yabbers14389353yabbers
yammers143410323yammers
yamuns11336513yam_uns

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.266671770.7
2DLD Change Limit1340272988.40615944.2
3Display Results2982980.1402128.6
 (SQL Overall)1786912988.81220278.1
 
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.