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

180 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
bassett9421386(None) 
basset85225381basse_t
bassets96414821bassets
bassetts10407371bassetts
assent65119952_assent
assert64922582_assert
asset55932262_asse_t
assets65617662_assets
basest84720492ba_sest
basket125722912baske_t
baskets135111832baskets
basses85428302basse_s
basseted1136752basseted
bassetted1244702bassetted
bassist9312742bassist
cassette1047812cassette
tasset65925312tasse_t
tassets75012772tassets
absent84016993_absent
ascent84519653_ascent
aspect10612823_aspect
assents74512223_assents
asserts74311793_asserts
asses55629283_asse_s
assess65710463_assess
assist6314603_assist
assort64916383_assort
baases85218013baase_s
babbitt1038033babbitt
babiest114414753babiest
backseat1648903backseat
backset15314193backse_t
backsets1638853backsets
baddest112611143baddest
baguet9316103bague_t
baguets1037483baguets
baguette11105933baguette
baldest102313533baldest
ballet84733973balle_t
ballets93719513ballets
bannet84925333banne_t
bannets94013843bannets
barbet104427883barbe_t
barbets114915843barbets
barbette1249113barbette
barest85327693ba_rest
barret84930483barre_t
barrets94917103barrets
barrette1039783barrette
basalt83519583ba_salt
basalts9358963basalts
base64847023ba_se__
based85331583ba_se_d
basely114412313ba_sely
basement12311493basement
baser74828923ba_se_r
bases75644353ba_se_s
bashed126225703bashe_d
basher115123813bashe_r
bashers124820833bashers
bashes115631393bashe_s
basilect1245903basilect
basinet9318933basinet
basinets1039063basinets
basked135218603baske_d
basketry1743513basketry
basmati1148233basmati
bass66146783bass___
basseting1236153basseting
bassetting1344633bassetting
bassi77019323bass__i
bassinet10312843bassinet
bassinets1146323bassinets
bassists1037183bassists
bassly114610073bass_ly
bassness1096743bassness
basso76017283bass__o
bassoon937613bassoon
bassos85313703bass_os
bassy1012917103bass__y
bast66362413ba_s__t
baste74829983ba_s_te
basted95227233baste_d
baster85333593baste_r
basters94930303basters
bastes85330383baste_s
basts75936933ba_s_ts
batt65053873ba___tt
bawsunt1244723bawsunt
beset76739133b_ese_t
besets85718803b_esets
biassed10418703biasse_d
biasses94911653biasse_s
bisect10312873b_isect
bosket124919223boske_t
boskets13409473boskets
bossed94816533bosse_d
bosses85925403bosse_s
bossiest103112213bossiest
brashest133511763brashest
brassart1047503brassart
brassed103612373brasse_d
brasses93818353brasse_s
brassiest11369713brassiest
busiest93716303busiest
bussed94717053busse_d
busses85023383busse_s
casette9310393ca_sette
casket124820993caske_t
caskets133910173caskets
cassata938143cassata
cassena9287843cassena
cassene93111543cassene
cassettes1146703cassettes
cosset84125863cosse_t
cossets95014283cossets
crassest103411523crassest
dessert82916453dessert
disseat83816923disseat
dissect103614133dissect
dissent84018683dissent
dissert83720693dissert
easiest72318773easiest
falsest10310013falsest
falsetto1143693falsetto
fastest102413723fastest
fossette1145263fossette
gashest114813413gashest
gasket114417253gaske_t
gaskets12348153gaskets
gassed85217633gasse_d
gasser75017773gasse_r
gassers84714633gassers
gasses75724783gasse_s
gassiest93212523gassiest
gusset7316433gusse_t
gussets837443gussets
haslet93222713hasle_t
haslets102510863haslets
hassel95614213hasse_l
hassels104311013hassels
lasses64827593lasse_s
masse75125293masse__
massed94421323masse_d
masses85028713masse_s
masseter1037063masseter
masseur935703masseur
massiest103314423massiest
misseat93617243misseat
missent94318713missent
misset85028153misse_t
missets94516573missets
nascent9610523nascent
passant9813943passant
passe75525693passe__
passed94320943passe_d
passee84522023passe_e
passel85117003passe_l
passels93913023passels
passer84721033passe_r
passers94717753passers
passes86030473passe_s
posset84923253posse_t
possets94212773possets
rashest103916873rashest
reassert8313673reassert
russet6319433russe_t
russets738163russets
russety1034613russety
sassed76116173sasse_d
sasses64124393sasse_s
sassiest83413613sassiest
sett45949053___sett
tasse54821843tasse__
tassel66014773tasse_l
tassels74510853tassels
tasses64826763tasse_s
vastest102911513vastest
wadset10314303wadse_t
wadsets1136443wadsets

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 Limit1340271806.36021073.4
3Display Results1801800.0632857.1
 (SQL Overall)1786911806.81326227.9
 
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.