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

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
conventionality2393041conventionality_
conventionalism22133153conventionali_sm
conventionalist20123533conventionali_st
conventionalize29102733conventionali_ze
conventionally2254983conventional_ly_
conditionality20113434con_ditionality_
conventional1757164conventional____
intentionality17113454_intentionality_
congeniality1854615congen_i__ality_
convectional1947045convectional____
convertibility2463275converti_bility_
intensionality17152955_intensionality_
conceptional1856916conceptional____
conceptuality2264476concept__uality_
conditionally1954796con_ditional_ly_
confectionaries22102336confectionari_es
confectionary2353776confectiona__ry_
confessionalism2272436confessionali_sm
confessionalist2072526confessionali_st
confessionally22103516confessional_ly_
confidentiality2471786confidenti__ality_
conjunctionally2972486conjunctional_ly_
connectional1646726connectional____
consentingly1854666consenti_ngl__y_
contentiously1854176contentiousl__y_
conveniently2054116conven_ientl__y_
convention15410566convention______
conventioneer18152626convention___eer
conventioneers1982396convention__eers
conventions16410536convention_____s
conventually2064896convent__ual_ly_
conversional1755146conversional____
conviviality2352516conv___iviality_
dimensionality2071526_dimensionality_
directionality2062506_directionality_
exceptionality2872116_exceptionality_
extensionality2461986_extensionality_
functionality2163536fun__ctionality_
intentionally1655986_intentional_ly_
nationality14147936__n__ationality_
notionality14126236__n__otionality_
optionality1654546_o___ptionality_
potentiality1754336po_tenti__ality_
unconventional1963126unconventional____

Search took 7 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.313570897.8
2DLD Change Limit65874445.81311332.2
3Display Results44440.0301466.7
 (SQL Overall)178691446.15629027.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.