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

78 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
hymnals154352(None) 
hymnal1434911hymnal_
cymbals16236142cymbals
hamals114816812ham_als
hammals14409212hammals
hyenas1288952hyena_s
hymenal1545182hymenal_
hymeneals1742532hymeneals
hymnary1843032hymnary
hymns1337522hymn__s
tymbals14265722tymbals
ammonals1245393ammonals
annals66415923_annals
canals84421663_canals
cymars13599143cym_ars
cymas126417883cym_a_s
cymbal15236913cymbal_
cymols1377193cym_ols
dynels10536813dy_nels
finals94316163_finals
gimbals12257823gimbals
gimmals12225823gimmals
gymnast1344153gymnast
gymnasts1442433gymnasts
halals95018313h_alals
hamal104623103ham_al_
hamauls12387803hamauls
hammal134512063hammal_
hammams13386433hammams
hamzahs24134373hamzahs
hamzas20119013hamza_s
hartals10313023hartals
heals85733453h__eals
hemal104419803hem_al_
hennas94211803henna_s
herbals122710603herbals
hobnails1343303hobnails
honans94814503h_onans
hryvnas1641493hryvna_s
humanly1545683humanly
humans112312433hum_ans
humerals1347163humerals
hyaenas1334983hyaena_s
hydras13239313hydra_s
hyena11810253hyena__
hyetal1236543hyetal_
hylas114815903hy_la_s
hymeneal1643473hymeneal_
hymenial1645293hymenial_
hymens1437993hym_ens
hymn12311313hymn___
hymnaries1754313hymnaries
hymned1535323hymn_ed
hymning1635183hymning
hymnist1546633hymnist
hymnists1644903hymnists
hymnless1632803hymnless
hymnody1942363hymnody
hyphal1736413hyphal_
jumbals18106533jumbals
laminals10339303laminals
mammals10389273mammals
meals75933373__meals
mynahs14416443my_nahs
mynas105815233my_na_s
nominals10278613nominals
sambals115213483sambals
signals8359163signals
simnels976103simnels
spinals93911863spinals
symbols1435523symbols
tamals84116623tam_als
thymols1533843thym_ols
timbals11239533timbals
tymbal13236823tymbal_
tympans14236813tympans
urinals7610253urinals
vinals94716483_vinals

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.1561145455.1
2DLD Change Limit134027787.28018410.3
3Display Results78780.0164875.0
 (SQL Overall)178691787.45223978.9
 
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.