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]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

113 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____
antirationality1872597antirationality_
centrality1547747c___ent__rality_
collegiality1863227colle_gi__ality_
commerciality2463387commerci__ality_
commonality2055537co____mmonality_
concentrically2063777concentrical_ly_
concentricity1963727concent__ricity_
concessionaire18142437concessiona_i_re
concessionaires19171947concessiona_ires
concessional16195397concessional____
concessionary2072937concessiona__ry_
concretionary2062867concretiona__ry_
condensational1753657condensational____
conditional1447117con_ditional____
conditionals1554977con_ditional___s
conductibility2462817conducti_bility_
confectioneries2292097confectioneri_es
confectionery2362567confection__ery_
confessional17175467confessional____
confessionals18154177confessional___s
congenialities1774197congen_i__alities
congenially1755907congen_i__al_ly_
congenitally1854397congen_i_tal_ly_
congressionally2172137congressional_ly_
conjugationally2862357conjugational_ly_
conjunctional2454167conjunctional____
connaturality1872477con__naturality_
connectivity2254557connecti___vity_
connubiality1952387con__n_ubiality_
contemptibility2691937contempti_bility_
contention12412227contention______
contentions13412097contention_____s
continuity1545997co___nti_n_uity_
convection17411127convection______
convections18411497convection_____s
conveniencies2074247conven_ien_ci_es
conveniency2154577conven_ien___cy_
convenient1549057conven_ien___t__
conventicle1854717conventi__cl___e
conventicler1962817conventi__cl__er
conventiclers2072097conventi__cl_ers
conventicles1954167conventi__cl__es
conventing16311547conventi_n_____g
conventual1546097convent__ual____
conventuals1665177convent__ual___s
conversational1954167conversational____
convertibly2155137converti__bl__y_
convincingly2352117convinci_ngl__y_
convocational2054477convocational____
convulsionary21101897convulsiona__ry_
correctional1675327correctional____
covetingly1944287co_ve_ti_ngl__y_
emotionality17144187___emotionality_
essentiality1563507_essenti__ality_
eventuality1753327__event__uality_
fictionality2054617___fictionality_
intensionally1654397_intensional_ly_
intentional11128857_intentional____
irrationality1654007__irrationality_
monumentality2063887monument___ality_
nonconventional20102597nonconventional____
polytonality2062347po__lyt_onality_
proportionality2272237proportionality_
rationality1458097____rationality_
subventionary2161637subventiona__ry_
uncongeniality20101577uncongen_i__ality_
unintentionally1872747unintentional_ly_
veniality1547597___ven_i__ality_
verticality1955057___verti_cality_

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.376475242.0
2DLD Change Limit950241139.20310325.3
3Display Results1131130.0931215.1
 (SQL Overall)1786911139.67218475.1
 
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.