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

87 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
arsenals84774(None) 
arsenal739381arsenal_
adrenals946312adrenals
arenas65021992ar_ena_s
arsenate81010482arsenate
arsenates979372arsenates
arsenicals1252972arsenicals
arsenics1056762arsenics
arsenous847532arsenous
abseils935973abse_ils
absences1247673absences
absently1345813absently
absents93510723absen_ts
acetals93411353a_cetals
adenyls1143923a_denyls
adrenal838263adrenal_
ammonals1245403ammonals
annals66415923a__nnals
anneals7449943anne_als
appeals11378673appe_als
ardently1247453ardently
areal55928733ar_e_al_
areas55935773ar_e_a_s
arecas84817443ar_eca_s
arena55323813ar_ena__
arenes64928393ar_en_es
arenous7314183ar_enous
areolas71013863ar_eolas
arepas85515703ar_epa_s
argals75517713ar__gals
argental947933argental_
argents84014853argen_ts
ariels65119373arie__ls
arousals866273arousals
arpens84814823arpen__s
arpents93613083arpen_ts
arrayals1154483arrayals
arrears738843arre_ars
arrivals1145943arrivals
arsenic939323arsen_ic
arsenical1145573arsenical_
arsenide9116333arsenide
arsenides1095613arsenides
arsenious945223arsenious
arsenite8119663arsenite
arsenites9149163arsenites
arseno6318913arsen__o
arses55733873arse___s
arsines73518813arsin_es
arsonous846393arsonous
arsons63917213arson__s
artels66216233arte__ls
arterials949693arterials
asanas6514113a_sana_s
assegais943953assegais
assents74512223assen_ts
astrals75515243a_strals
australs8359533australs
cardinals1248003cardinals
cassenas10317483cassena_s
crenels93711013cr_enels
fresnels1135233fresnels
juvenals1842773juvenals
marginals1246013marginals
marshals1337783mars_hals
ordeals877993orde_als
ordinals946763ordinals
orientals946903orientals
parietals1146863parietals
personals11238573personals
rascals959663ras_cals
reals55038653_r_e_als
renails74917263_r_enails
renal55929503_r_enal_
rentals74017473_r_entals
reseals73917663_reseals
sarsenets946513sarsenets
sarsens7311393sarsen__s
seals54839693__se_als
sendals81912263__sendals
sepals85217373__sepals
tarsals72512603tars__als
treenails945563treenails
trenails869843tr_enails
unseals73212573unse_als
urinals7610263ur_inals
varietals1244443varietals

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 Filter1786911461620.423422437.4
2DLD Change Limit146162877.79618748.3
3Display Results87870.0302900.0
 (SQL Overall)178691878.24921662.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.