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
apterium124915(None) 
apteria9312922apteri_a
apterous10410482apterous
asterism10413272asterism
atrium8411832a_t_rium
bacterium1546682bacterium
actinium1297563actinium
aecium10410423a__ecium
altering91917123altering
alterity1149853alterity
anterior8611073anterior
anteroom101010103anteroom
anthurium1444373anthurium
antrum8611313ant_r_um
apercu1057383ap_ercu_
apercus1136573ap_ercus
aperies9423203ap_eries
aphorism1548643aphorism
apothecium1952573apothecium
apter76120203apter___
apteral9311523apter_al
apteryx1942383apter_yx
aquarium1945383aquarium
arterial8313653arterial
arteries8321513arteries
asteria7316203asteri_a
asterias8317033asterias
asterisk1248693asterisk
asterisms11511083asterisms
atriums939063a_t_riums
autecism1247073autecism
auteurism1144623auteurism
bothrium1585023bothrium
cerium10313773__cerium
criterium1346413criterium
deuterium1245133deuterium
elaterium1146363elaterium
imperium1446423imperium
interim9912873interi_m
iterum837903_iter_um
lutecium1244393lutecium
lutetium1044243lutetium
natrium948993nat_rium
pastorium1347713pastorium
patagium1375433patagium
premium13310363_premium
psalterium1452843psalterium
pterin81014153_pteri_n
pterins9812993_pterins
pterygium1751923_pterygium
septarium1345163septarium
splenium1246473splenium
sternum947733_sternum
tedium9269873__tedium
telium82611403__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.423422437.4
2DLD Change Limit146162596.78021557.8
3Display Results59590.0331787.9
 (SQL Overall)178691597.23624694.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.