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 “wassails” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

99 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
wassails114595(None) 
assails769091_assails
wassail1056131wassail_
assail6610152_assail_
assais6711962_assai_s
assoils776662_assoils
reassails945292reassails
vassals1057952vassa_ls
wagtails1244442wagtails
wassailed1343152wassailed
wassailer1242782wassailer
wassailers1342342wassailers
abseils935973_abseils
agnails837003_agnails
assai5711543_assai__
assailed945323_assailed
assailer844823_assailer
assailers943983_assailers
assault747413_assault
assaults843863_assaults
assays977903_assa_ys
assoil688543_assoil_
avails939693_a_vails
basils85717473ba_s_ils
camails11311753ca_mails
cassabas1245733cassabas
cassatas1036683cassatas
cassavas1344803cassavas
cassias93514343cass_ias
cassis84818853cass_i_s
casuals91410523casua_ls
cattails1038553cattails
causals91411183causa_ls
dassies84418663dass_ies
dossals8379293dossa_ls
dossils8669773doss_ils
fantails1139693fantails
fossils10379013foss_ils
gassily1137813gass_ily
hassels104311013hass_els
headsails1343943headsails
jassids1586143jass_ids
lassies74420103lass_ies
lassis65216703lass_i_s
lugsails942743lugsails
mainsails1144853mainsails
massages1159883massages
massas85116463massa__s
massifs1237743mass_ifs
missals93914423missa_ls
nasals63312463na_sa_ls
outsails8139863outsails
parasails1147583parasails
pascals11610013pasca_ls
pasquils1943123pasquils
passable12310633passable
passably1537253passably
passades1139203passades
passados1146303passados
passages1139513passages
passels93913023pass_els
pastils94416173pa_stils
rascals959663rasca_ls
rattails837133rattails
reassail845753reassail_
resails74616743_resails
sails55738103___sails
sassabies1144143sassabies
sassies74719263sass_ies
sassily1038723sass_ily
skysails1552493skysails
snails64816653__snails
spails84817823__spails
staysails1242853staysails
swails94913123__swails
tahsils1035053tahs_ils
tarsals72512603tarsa_ls
tassels74510853tass_els
tassies74918933tass_ies
topsails1075093topsails
trysails1144163trysails
vassal979243vassa_l_
wadmaals1442413wadmaals
wadmals1335513wadma_ls
wagtail1145043wagtail_
wails86631483w___ails
warsaws1335763warsa_ws
warships1647553warships
wasabis1255363wa_sabis
washable16138043washable
washables17144743washables
waspily1535513wa_spily
wassailing1443593wassailing
wastable131410453wastable
wastages12109753wastages
wastrels1136203wastrels
wastries111212883wastries
wessands1243683wessands
wussies103411083wuss_ies

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162997.59319249.6
3Display Results99990.0303300.0
 (SQL Overall)178691997.77922970.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.