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

92 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
confectioneries229208(None) 
confectionaries22102311confectionaries
confectioners2073362confectioner__s
confectioner1964143confectioner___
confectionery2362563confectioner__y
confectionary2353754confectionar__y
confections18411364confection____s
concessionaires19171915concessionaires
concessioners1753045concessioner__s
conditioners1563925con_ditioner__s
confection17411185confection_____
connectednesses2063335connectednesses
connections15410685connection____s
connectivities2164475connecti_vities
convections18411475convection____s
conventioneer18152625conventione__er
conventioneers1982395conventione_ers
festooneries1552175___festooneries
functionaries1863015fun__ctionaries
lectionaries1454765___lectionaries
colectomies1756756co_lect_o__mies
collectednesses2062576collectednesses
collections1547916collection____s
collectivities2174166collecti_vities
conceitednesses2063676conceitednesses
conceptions17410546conception____s
concertednesses2064186concertednesses
concertgoers1752586concertgo_er__s
concessionaire18142406concessionaire_
concessioner1653666concessioner___
concierges1544546con__c_i__erges
concinnities1654406con__c_innities
concoctions1448236concoction____s
conditioner1474666con_ditioner___
conductions1649646conduction____s
conductivities2283566conducti_vities
confecting18310556confecti_n____g
confessionalism2272396confessionalism
confessionalist2072486confessionalist
confessionals18154136confession__als
confessions16136606confession____s
confiners1439956conf___i_ner__s
conflations16411136conflation____s
conflictions1945226confliction____s
confraternities2091536confraternities
congestions1449296congestion____s
conjecturers23152426conject_urer__s
conjectures22134896conject___ur_es
connectedness1884456connectedne__ss
connecters1448016connect___er__s
connection14410536connection_____
connectional1646696connection___al
connectives1847506connecti____ves
connectors1448176connect_o__r__s
conniveries1644706con___ni_veries
consecutions1647036consecution____s
consistories1455076consist_o__ries
containerise1453976con___tainerise
containerises1553166con___tainerises
containerizes2462726con___tainerizes
contemporaries2062526conte_mporaries
contentednesses1863726contentednesses
contentions13412086contention____s
continences1588586con___ti_nences
controversies1863346con___troversies
convection17411126convection_____
convectional1947016convection___al
convectors1768296convect_o__r__s
conveniencies2074246conve_nien_cies
conventiclers2072086conventicler__s
conventionalism22133126conventionalism
conventionalist20123486conventionalist
conventionality2393016conventionality
conventionalize29102706conventionalize
conventions16410526convention____s
convictions1848036conviction____s
cordwaineries1961356co_rdwai_neries
corrections1548836correction____s
correctnesses1754206correct__nesses
corsetieres1352896corse_ti__er_es
dictionaries1554786___dictionaries
infections15510236_infection____s
infectivities2155126_infecti_vities
nondeliveries1762296nonde_li_veries
nonfictions1645926nonfiction____s
octonaries1246006_o___ct_onaries
offertories1752656_offert_o__ries
olfactories1653546_olfact_o__ries
questionaries2262316__questionaries
reactionaries1553546__reactionaries
refectories1646416_refect_o__ries
stationeries1252836___stationeries

Search took 9 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.1231452772.4
2DLD Change Limit95024927.86012089.6
3Display Results92920.0631460.3
 (SQL Overall)178691928.04622208.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.