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

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

89 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
misrecollection2171351misrecollection_
recollection1654854___recollection_
recollections1754724___recollections
misconnection1954135mis__connection_
misconnections2063815mis__connections
recollecting1764085___recollecti_ng
subcollection1961715__subcollection_
subcollections2061725__subcollections
collection1448206_____collection_
collections1547936_____collections
disconnection1854206dis__connection_
disconnections1954026dis__connections
intellection1466166_inte__llection_
intellections1565386_inte__llections
misconception2163996mis__conception_
misconceptions2263576mis__conceptions
misconnecting2053546mis__connecti_ng
reconnection1655996___reconnection_
reconnections1765756___reconnections
collecting1548287_____collecti_ng
decollation1448197___decoll_ation_
decollations1547367___decoll_ations
discoloration16124727dis__coloration_
discolorations17104307dis__colorations
disconnecting1953887dis__connecti_ng
disrelation1248817disre___l_ation_
disrelations1348507disre___l_ations
disrespecting1952437disre__specti_ng
hypercorrection27132197hypercorrection_
interconnection1963127_interconnection_
irresolution12132417_irreso_l_ution_
irresolutions13162377_irreso_l_utions
microdissection2271417microdissection_
microelectrode2172447micr__oelectrode
microelectronic20112537micr__oelectronic
microevolution2182647microevo_l_ution_
microevolutions2282337microevo_l_utions
microinjection2762557micr_oinjection_
microinjections2862427micr_oinjections
microprojection3072657microprojection_
misallocation1753367mis___allocation_
misallocations1853097mis___allocations
misconducting2152717mis__conducti_ng
miscorrelation1873237mis__correlation_
miscorrelations1963007mis__correlations
miscreation1547717mis__c__reation_
miscreations1647057mis__c__reations
misdirection1754157mis___direction_
misdirections1854227mis___directions
misevaluation18153627mis_e_valuation_
misevaluations19133457mis_e_valuations
misperception2162877mispe__rception_
misperceptions2262487mispe__rceptions
misrecording1872227misreco___rdi_ng
misregistration1871447misregistration_
misrelating1447277misre___l_ati_ng
misreporting1753237misrepo___rti_ng
misrepresenting2071437misrepresenti_ng
misvocalization3163057misvocalization_
postelection1654547poste___lection_
preconception2154287__preconception_
preconceptions2253887__preconceptions
preconvention2074007__preconvention_
preconviction2253707__preconviction_
preconvictions2353357__preconvictions
predilection1754097__pre_dilection_
predilections1853557__pre_dilections
preelection15136487__pre__election_
prelection141511297__pre___lection_
prelections151210467__pre___lections
preselection16154887__pre_selection_
preselections17144447__pre_selections
recollect1345707___recollect____
recollected1643857___recollect__ed
recollects1443687___recollect___s
reconception1855647___reconception_
reconceptions1965127___reconceptions
reconnecting1745357___reconnecti_ng
reconviction1955087___reconviction_
reconvictions2054877___reconvictions
reelection12198637___re__election_
reelections13167947___re__elections
reflection15168997___re__flection_
reflectional1753987___re__flectional
reflections16178557___re__flections
retroflection1854047___retroflection_
retroflections1953877___retroflections
selection11311277__s_e___lection_
selections12310877__s_e___lections

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.1231452772.4
2DLD Change Limit95024899.5639936.6
3Display Results89890.0801112.5
 (SQL Overall)178691899.76618297.3
 
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.