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

59 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
apterium124913(None) 
apteria9312912apteri_a
apterous10410462apterous
asterism10413252asterism
atrium8411822a_t_rium
bacterium1546672bacterium
actinium1297553actinium
aecium10410423a__ecium
altering91917113altering
alterity1149843alterity
anterior8611053anterior
anteroom101010103anteroom
anthurium1444373anthurium
antrum8611313ant_r_um
apercu1057383ap_ercu_
apercus1136573ap_ercus
aperies9423203ap_eries
aphorism1548643aphorism
apothecium1952573apothecium
apter76120203apter___
apteral9311523apter_al
apteryx1942383apter_yx
aquarium1945383aquarium
arterial8313633arterial
arteries8321483arteries
asteria7316183asteri_a
asterias8317013asterias
asterisk1248673asterisk
asterisms11511063asterisms
atriums939043a_t_riums
autecism1247073autecism
auteurism1144613auteurism
bothrium1585013bothrium
cerium10313763__cerium
criterium1346393criterium
deuterium1245123deuterium
elaterium1146353elaterium
imperium1446423imperium
interim9912873interi_m
iterum837903_iter_um
lutecium1244393lutecium
lutetium1044243lutetium
natrium948983nat_rium
pastorium1347693pastorium
patagium1375423patagium
premium13310363_premium
psalterium1452833psalterium
pterin81014153_pteri_n
pterins9812993_pterins
pterygium1751923_pterygium
septarium1345163septarium
splenium1246473splenium
sternum947733_sternum
tedium9269873__tedium
telium82611393__telium
terbium1147293__terbium
tergum937933__tergum
ytterbium1652223ytterbium
yttrium1244103_yttrium

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.1531167915.0
2DLD Change Limit146162597.62619166.3
3Display Results59590.0301966.7
 (SQL Overall)178691597.80922882.7
 
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.