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

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

44 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
experientially269270(None) 
experiential2163792experientia_l_
experimentally2863072experiment_ally
expediential2262743expedientia_l_
exponentially2562513exp_onentially
deferentially2063714defer_entially
existentially2363184ex_istentially
expediently2453794expedient___ly
experimental2364124experiment_a_l_
inferentially1955494infer_entially
penitentially1854294__penitentially
perennially1654604__per_ennially
referentially1963524refer_entially
reverentially1963274rever_entially
biparentally1962195bipar_ent_ally
differentially2463135differ_entially
elementally1654195e_le_ment_ally
energetically1985275e_nerge_tically
essentially1455125___essentially
evidentially1954055e__videntially
experiencing2452655experienci__ng
experimentalism2893265experiment_alism
experimentalist26113265experiment_alist
experimenting2562375experimenti__ng
exponential20112845exp_onentia_l_
exponentials21102235exp_onentia_ls
externally2045545exter__n__ally
extrinsically2562605ex_tri_nsically
interdentally1755365interdent_ally
orientally1346215___orient_ally
parentally1546205__par_ent_ally
perceptually2153065__perceptually
perinatally1653445__peri_natally
perpetually1853865__perpe_tually
pestilentially1982245__pestilentially
potentially1656805__p_otentially
preferentially2262835prefer_entially
presidentially2063225_presidentially
prudentially1854155__prudentially
residentially1773845__residentially
sequentially2483575__sequentially
temperamentally2481685temperament_ally
torrentially1553755__torrentially
triennially1453365___triennially

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.656272394.8
2DLD Change Limit95024448.64010998.1
3Display Results44440.063698.4
 (SQL Overall)178691449.35919093.0
 
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.