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

262 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
buttals93850(None) 
abuttals1043921abuttals
abettals1054722abettals
abuttal954552abuttal_
bettas84913922betta_s
bubals103513842bu_bals
burials93612082burials
butters94521722butters
buttes84822562butt_es
butties93217952butties
buttons9310332buttons
butts75824252butt__s
butyls1176752bu_tyls
butyrals1344502butyrals
curtals93111622curtals
mutuals937132mutuals
outtalk1138232outtalk
outtalks1236502outtalks
rebuttals1142862rebuttals
suttas63813792sutta_s
abettal946073abettal_
abutters1056993abutters
acetals93411353acetals
astrals75515243astrals
attars64515313_attars
australs8359533australs
baals76122703b__aals
bals66354043b___als
bantams1149063bantams
battalia1045303battalia
battalias1144803battalias
battens95313263battens
batters94626023batters
battiks1337143battiks
battle85217863batt_le
battles94517683battles
batts76727563batt__s
battues94610193battues
betas75528763b_eta_s
betels84515063b_etels
bethels1238533bethels
betrays12127823betrays
betta74916843betta__
betters94422093betters
bettors93312473bettors
bharals1236733bharals
bimetals1246953bimetals
biotas84313923biota_s
bitmaps1344253bitmaps
bitters94920363bitters
bitts75022593bitt__s
boatels93510233boatels
bobtails1245193bobtails
borals86721913b_orals
borstals1037473borstals
botas75328783b_ota_s
botels84815803b_otels
bottle84916073bott_le
bottles94216273bottles
bottoms1136993bottoms
botts75224863bott__s
bridals1038623bridals
bromals1139743bromals
brutal859383brutal_
bubal94218213bu_bal_
bubale104014623bu_bale
bubales113513343bu_bales
bubalis11359903bu_balis
bubbas94110703bubba_s
buccal1248243buccal_
bucktails1743553bucktails
buffalo1553723buffalo
buffalos1642863buffalos
buhls105111803bu__hls
bulbels11398013bulbels
bulbils11338333bulbils
bulbuls11346783bulbuls
bulls75629573bu__lls
bummalo1353793bummalo
bummalos1442873bummalos
bunas75126573bu_na_s
bunters94717123bunters
bunts75729803bunt__s
bunyas11359433bunya_s
burans85019303bu_rans
buras74736303bu_ra_s
bureaus979293bureaus
burial84117623burial_
burkas124513803burka_s
burlaps1156253burlaps
burls74228853bu__rls
burqas174410903burqa_s
bursal84414823bursal_
bursars94510893bursars
bursas85318273bursa_s
burtons9310853burtons
busbars1138153busbars
bushels124110713bushels
bustard10389723bustard
bustards11308513bustards
busters94724133busters
bustics11810883bustics
bustle84015483bust_le
bustles93816323bustles
busts75227693bust__s
butane8313653bu_tane
butanes9312743butanes
butanols1044713butanols
butches144315363butches
butenes9313033butenes
buteos84913413bu_teos
butes714535873bu_t_es
butle75023103bu_t_le
butlers94518053butlers
butles84423913bu_tles
buts67247693bu_t__s
butt65143743butt___
butte74924293butt__e
butted94722063butt_ed
butter84724233butt_er
buttery124311193buttery
buttheads1553903buttheads
butting103519283butting
buttock1545563buttock
buttocks1645233buttocks
button8310273butt_on
buttony1236173buttony
buttress1035883buttress
butty104020113butt__y
bututs8409423bu_tuts
butyl1089103bu_tyl_
butyral1245713butyral_
butyryls1641873butyryls
bytalk1533473b_ytalk
bytalks1632713b_ytalks
cantals93919573cantals
cattails1038553cattails
cattalo938423cattalo
cattalos1037933cattalos
centals94317053centals
citrals91111673citrals
cottars94412243cottars
cottas84615573cotta_s
curtails10318243curtails
curtal83914543curtal_
cutlas8313103cutla_s
cutlass938013cutlass
cuttable1247953cuttable
cuttage10318343cuttage
cuttages11297223cuttages
cutters94218963cutters
cutties93118843cutties
cuttle84113893cutt_le
cuttles93613923cuttles
dentals83915393dentals
dottels8327783dottels
duals65620083du__als
ductal938993ductal_
fetials103711743fetials
fungals11276783fungals
guitars8116863guitars
gutta64613383gutta__
guttae73210583gutta_e
guttate8328903guttate
gutters83715513gutters
guttle74111973gutt_le
guttles83011933guttles
gutturals1043023gutturals
hartals10313023hartals
instals7611713instals
jumbals18106533jumbals
juntas134210503junta_s
jutties143814003jutties
kurtas10349883kurta_s
lethals1038113lethals
luteal64411483luteal_
lyttas985073lytta_s
metals84520893_metals
mortals93914013mortals
mughals1355763mughals
murals84016763mu_rals
mutates92215793mutates
mutters94117143mutters
muttons949283muttons
mutts75120253mutt__s
mutual838503mutual_
mutuels935943mutuels
neutrals846283neutrals
nuchals12216943nuchals
nuptials1044303nuptials
nutates73214973nutates
nutgall844443nutgall
nutgalls943953nutgalls
nutters74215433nutters
nuttily10308633nuttily
ottars64112223_ottars
outbawls1336053outbawls
outcall9310123outcall
outcalls1038743outcalls
outeats72215703outeats
outfall1039683outfall
outfalls1138143outfalls
outgas7313203outga_s
outhauls1137223outhauls
outlaws10249603outlaws
outlays102610903outlays
outmans92413283outmans
outpass939713outpass
outsails8139863outsails
outsays102710403outsays
outstays1156623outstays
outtake11310793outtake
outtakes12310033outtakes
outtask1137053outtask
outtasks1235633outtasks
outtell797883outtell
outtells896853outtells
outtold8107603outtold
outwalk1437623outwalk
outwalks1535993outwalks
outwars10912793outwars
petals84719813_petals
pittas86014523pitta_s
portals94015563portals
postals93716383postals
puttees93612913puttees
putters94219193putters
putties94420023putties
putts75719273putt__s
quetzals2642583quetzals
quezals2544253quezals
quintals17288003quintals
quotas15339433quota_s
ratals64219583_ratals
rattails837133rattails
rattans73411953rattans
rebuttal1043993rebuttal_
rentals74017483rentals
retotals838463retotals
rituals738353rituals
ruttily10338613ruttily
spitals93011593spitals
steals64020063_steals
subtotals1144993subtotals
sultans72411833sultans
suntans72111733suntans
sutras64818593sutra_s
sutta54015333sutta__
suttees74114063suttees
teals56234133__teals
totals63115163_totals
tutties73216473tutties
tuttis63611373tutt_is
uptalk1234653_uptalk
uptalks1333723_uptalks
urials64415193_urials
usuals637793_usuals
utas45924953_u_ta_s
utters63817123_utters
vestals104612333vestals
vitals94514303_vitals
wittols1035733wittols

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 Limit1340272625.76623244.4
3Display Results2622620.0932817.2
 (SQL Overall)1786912626.24928595.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.