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

77 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
reconvictions205487(None) 
preconvictions2353351preconvictions
reconviction1955081reconviction_
convictions1848032__convictions
preconviction2253702preconviction_
reconditions1546812recondi_tions
reconnections1765742reconnections
reconvicting20114612reconvicti_ng
convections18411473__convections
conviction1748183__conviction_
deconditions1645273decondi_tions
preconditions1854883precondi_tions
recognitions1544853recogni_tions
recollections1754723recollections
reconceptions1965093reconceptions
recondition1447123recondi_tion_
reconnection1655983reconnection_
reconversions1853863reconversions
reconvicts1744383reconvict___s
concoctions1448234__concoctions
conditions13410094__condi_tions
conductions1649644__conductions
confections18411364__confections
conflictions1945224__conflictions
connections15410684__connections
conniptions1546024__conniptions
convection17411124__convection_
conventions16410524__conventions
convicting1847574__convicti_ng
convocations1947344__convocations
decoctions1547134deco___ctions
decondition1545414decondi_tion_
decongestions1753564decongestions
decortications1966764decortications
evictions14228624_e___victions
nonfictions1645934__nonfictions
precognitions1853594precogni_tions
preconceptions2253844preconceptions
precondition1755244precondi_tion_
preconvention2074004preconvention_
premonitions1646854premon_i_tions
recantations1448874recan_tations
recodifications23165454recodifications
recognition1445204recogni_tion_
recollection1654854recollection_
recombinations2095584recombinations
recommissions1953654recommissions
recompilations2054934recompilations
reconception1855624reconception_
reconciliations1953734reconciliations
reconditioned1783274recondi_tioned
reconducting1854714reconducti_ng
reconfirmations2283084reconfirmations
reconnecting1745334reconnecti_ng
reconsecrations1995084reconsecrations
reconstitutions1763264reconstitutions
reconstructions19124724reconstructions
recontacting1745054recontacti_ng
reconversion1754024reconversion_
reconverting1876394reconverti_ng
reconvict1646084reconvict____
reconvicted1944274reconvict__ed
reconvincing2053164reconvinci_ng
recordations1548624reco_rdations
rectifications2148914rectifications
reignitions1244554reign_i_tions
reinfections1745324re_infections
reinjections2144404re_injections
reinventions1554214re_inventions
relictions12310024re___lictions
remotivations1846684remotivations
renditions1149184re__ndi_tions
renovations1448414reno_v_ations
renunciations1554854renunciations
repositions131110144repo_si_tions
restrictions1449274re_strictions
retrodictions1655534retrodictions

Search took 8 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.1261418182.5
2DLD Change Limit95024777.39012858.5
3Display Results77770.0631222.2
 (SQL Overall)178691777.57923577.1
 
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.