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

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

45 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
temperamentally2481681temperamentally_
temperamental1962143temperamenta_l__
experimentally2863074_experimentally_
departmentally2271845de_partmentally_
temperament1754865temperament_____
temperaments1853665temperament____s
detrimentally1963766de__trimentally_
elementally1654196_e_le__mentally_
experientially2692706_exper_ientially_
experimental2364126_experimenta_l__
experimentalism2893266_experimentalism
experimentalist26113266_experimentalist
governmentally2372376_governmentally_
sacramentally2062746__sacramentally_
temperately1853206tempera___t_ely_
biparentally1962197_bip__arentally_
compartmental2162487compartmenta_l__
deferentially2063717de_fer__entially_
departmental1762767de_partmenta_l__
departmentalize2971847de_partmentalize
developmentally2681257developmentally_
environmentally2371327_environmentally_
experimentation2662717_experimentation
fragmentally2183027____fragmentally_
fundamentally2262267__fundamentally_
impermanently2262107_impermanent__ly_
impersonally1953907_imper_son_ally_
incrementally2064667__incrementally_
instrumentally1973017_instrumentally_
interdentally1755367_inter_dentally_
monumentally1953987__m_onumentally_
ornamentally1763337___ornamentally_
parentally1546207___p__arentally_
referentially1963527re_fer__entially_
reverentially1963277re_ver__entially_
segmentally1754327___se_gmentally_
sentimentally1874147se__ntimentally_
temperateness1764427temperaten___ess
temperatenesses19113157temperaten_esses
temporally1744227tempor_____ally_
terminally1567027t___er_min_ally_
testamentary1761667te__stamenta_ry_
tetragonally1662597te__tragon_ally_
tetrahedrally2071807te__trahedrally_
uniparentally1862267unip__arentally_

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 Filter178691950240.360496363.9
2DLD Change Limit95024459.03010523.1
3Display Results45450.050900.0
 (SQL Overall)178691459.44018929.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.