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

30 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
practicalities205356(None) 
criticalities1754683cr_iticalities
farcicalities2053573farc_icalities
partialities14108033p_arti_alities
practicality2153593practicalit__y
actualities1346824__act_ualities
classicalities1862534classicalities
cyclicalities1953034_cyclicalities
erectilities1447124erecti__lities
facticities1846874_factic__ities
factualities1754534_fact_ualities
gracilities1447684grac_i__lities
parfocalities2053714p_arfocalities
partibilities1748094p_artibilities
physicalities2393644p_hysicalities
plasticities1655554plastic__ities
practicability2553324practicability
practicalness1953324practical_ness
practicalnesses2162954practicalnesses
practicals1645544practical____s
primalities1548294pr___imalities
principalities2083204principalities
prodigalities1763934pr_odigalities
punctualities1753464punct_ualities
rascalities1347224_ra__scalities
rationalities1357284_ra_tionalities
spatialities1465564spa_ti_alities
tactilities1347674_tacti__lities
tractabilities1846614tractabilities
verticalities1885214_verticalities

Search took 4 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 Filter178691658740.330541487.9
2DLD Change Limit65874303.12621072.9
3Display Results30300.0301000.0
 (SQL Overall)178691303.48651259.6
 
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.