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

203 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
sacbuts116647(None) 
sacbut10811941sacbut_
sackbuts1644051sackbuts
sagbuts1065221sagbuts
abuts75417072_a_buts
barbuts11439842barbuts
hackbuts1943872hackbuts
hagbuts1354922hagbuts
sabbats1138632sabbats
sabots8314692sa_bots
sachets123914102sachets
sackbut1545942sackbut_
sacques18106862sacques
sacrums11388042sacrums
sagbut959752sagbut_
samburs11369342samburs
scouts84817942s_couts
scuts74522522s_c_uts
abbots1039283_abbots
abets75621673_a_bets
abut66834953_a_but_
acquits1857293_acquits
acts66929863_ac__ts
acute74720363_ac_ute
acutes83917723_ac_utes
albums10198273_albums
ambits103713393_ambits
arbute8311043_arbute
arbutes939703_arbutes
arbutus944843_arbutus
ascents93812553ascents
ascots85312513asc_ots
ascus75013583asc_u_s
babuls105413643ba_buls
babus95620333ba_bu_s
backouts1698643backouts
backups1736173backups
barbets114915843barbets
barbut104617003barbut_
buts67247693___buts
cachets145014263cachets
cactus104912233cactu_s
catguts1045313catguts
cuts65841153__c_uts
dacoits1079073dacoits
dauts67822243da__uts
debuts93911753_debuts
earbuds1044633earbuds
facets116316653fac_ets
facts107021893fac__ts
gambits12399713gambits
gamuts958783ga_muts
habits113014643ha_bits
habus106317143ha_bu_s
hackbut1845713hackbut_
hagbut1278913hagbut_
halibuts1364443halibuts
iambus10468893iambu_s
jabots1538883ja_bots
jackets205011373jackets
jacobus1843173jacobu_s
krubuts1343003krubuts
layouts1046483layouts
mahouts1237143mahouts
mauts75927193ma__uts
packets155114773packets
pacts95125803pac__ts
payouts1247303payouts
rabats83116223ra_bats
rabbets11279423rabbets
rabbits11299863rabbits
rachets124516833rachets
racists92613323racists
rackets134916873rackets
racquets1944763racquets
ragouts838533ragouts
rebuts84015193_rebuts
recuts83817373rec_uts
sabals84618863sa_bals
sabbat10314713sabbat_
sabbath1445393sabbath
sabbaths1543973sabbaths
sabers85224733sa_bers
sabes76437463sa_b_es
sabins85521973sa_bins
sabirs85414623sa_birs
sables85026693sa_bles
sabot7931773sa_bot_
sabras85116363sa_bras
sabres85520863sa_bres
sabs66643743sa_b__s
saccate111311763saccate
saccule1136743saccule
saccules1237033saccules
sacculi1145043sacculi
sacculus1244813sacculus
sachems14348903sachems
sachet114725773sachet_
sackers133820223sackers
sackfuls1744163sackfuls
sacks114228873sac__ks
sacque17107113sacqu_e
sacrals93311793sacrals
sacrist9315423sacrist
sacrists1039563sacrists
sacrum103910143sacru_m
sacs65739073sac___s
sadhus10298463sadhu_s
sadists83310853sadists
saints65122423sa_ints
sajous13310583sajou_s
sallets73719653sallets
salts55431883sa__lts
salute64418023sa_lute
salutes73716253sa_lutes
sambals115213483sambals
sambars115113843sambars
sambas104219263samb_as
sambhurs1543183sambhurs
sambos104315193samb_os
sambuca1344343sambuca
sambucas1444163sambucas
sambuke1544203sambuke
sambukes1644193sambukes
sambur10469503sambu_r
samlets93813553samlets
sanctums1244013sanctums
sandburs11105623sandburs
sannups934463sannups
santurs7310763santurs
sapours93610613sapours
sarcous9312933sarcou_s
sauls55128123sa__uls
saults65816173sa_ults
saute55028083sa__ute
sautes63924913sa__utes
savants1038653savants
savours10389333savours
sawbuck1843923sawbuck
sawbucks1943413sawbucks
sawdust1154533sawdust
sawdusts1242333sawdusts
scabies11613333scabies
scabs94818643scab__s
scants85219723s_cants
scarts85321493s_carts
scats75930603s_c_ats
scatts85914663s_catts
scaups105411933s_caups
scaurs85512043s_caurs
scents85317023s_cents
schuits1235823s_chuits
schuls11299853s_chuls
schuss11186733s_chuss
scoots85315933s_coots
scots74025903s_c_ots
scours84913583s_cours
scout75031453s_cout_
scouth115011153s_couth
scouths12527893s_couths
scrubs104210313s_crubs
scrums104614253s_crums
scubas103710223s_cubas
scuds85116243s_c_uds
scums95017423s_c_ums
scups95316653s_c_ups
scut65835543s_c_ut_
scuta75815753s_c_uta
scute75520943s_c_ute
scutes85219193s_c_utes
seascouts1144313seascouts
sebums10369813s_ebums
secants93413893secants
secrets9311773secrets
sects75622893sec__ts
setouts74110333setouts
shouts94017713s_houts
shuts85622473s__huts
sickouts1455503sickouts
sluts54523983s__luts
smuts75415713s__muts
snouts64915863s_nouts
sockets134012983sockets
sorbets93012503sorbets
spambots1443313spambots
spouts85115113s_pouts
sprouts949983sprouts
stackups1643313stackups
stouts65019003s_touts
struts65616803s_truts
subcults1246923subcults
subcutes1238573subcutes
subcutis1246283subcutis
succuss1134993succuss
tabuns8489223ta_buns
tabus74820923ta_bu_s
tackets134914363tackets
tacts76524123tac__ts
tamburs11288603tamburs
tauts56125513ta__uts
vacuums1443403vacuums
walnuts1033843walnuts
yachts1437023yac_hts

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.190940478.9
2DLD Change Limit1340272037.64017542.8
3Display Results2032030.0633222.2
 (SQL Overall)1786912037.89322639.2
 
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.