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

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

50 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
elementally165419(None) 
elemental1145882elementa_l_
elementals1254792elementa_ls
elementarily1762722elementarily
elementary1553642elementa_ry
clemently1645063clement__ly
lamentably1743713_lamentably
mentally131010403___mentally
segmentally1754323segmentally
alimental1155864alimenta_l_
alimentary1553984alimenta_ry
ceremonially1953384ceremonially
commensally2054794commensally
deferentially2063714deferentially
dementedly1743924_dementedly
dentally121110064___dentally
detrimentally1963764detrimentally
ecumenically2154394ecumenically
electorally1654274electorally
elegantly1343984elegant__ly
elegiacally1752264elegiacally
element9317804element____
elements10312174element___s
ephemerally2152604epheme_rally
essentially1455124e_ssentially
eternally1247494ete_rn_ally
eventually1644584__eventually
evidentially1954054evidentially
experimentally2863074experimentally
fragmentally2183024fragmentally
geminally1576404_gemin_ally
hymeneally2151904_hymeneally
incrementally2064664incrementally
judgmentally2661874judgmentally
lamentable1444204_lamentable
lamentedly1652264_lamentedly
menially131111094___menially
monumentally1953984monumentally
orientally1346214_orientally
ornamentally1763334ornamentally
parentally1546204_parentally
presentably1855284presentably
referentially1963524referentially
remedially1644374_remedially
reverentially1963274reverentially
seminally1458804_semin_ally
sentimentally1874144sentimentally
skeletally17112994skele_tally
vegetally1644214_vege_tally
vehemently2152894vehement__ly

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit148819509.40615821.7
3Display Results50500.0301666.7
 (SQL Overall)178691509.85918124.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.