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

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

86 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
convection1741112(None) 
confection17411181confection
connection14410531connection
convections18411491convections
convention15410561convention
conviction1748181conviction
collection1448202collection
conception16410452conception
concoction1348232concoction
conduction1549962conduction
confections18411392confections
congestion1349042congestion
connections15410702connections
consecution1547302consecution
contention12412222contention
convecting18310432convecting
convectional1947042convectional
convective2049112convective
convector1648082convect_or
conventions16410532conventions
conversion1548422conversion
convictions1848042convictions
convocation1847882convocation
correction1448812correction
advection1545553_advection
bolection13117673bo_lection
coaction12310773co__action
codirection1644743codirection
cofunction1745253cofunction
collections1547933collections
compaction1846753compaction
conation101420883con__ation
conceptions17410593conceptions
concertino14910843concertino
concession14148133concession
concoctions1448253concoctions
concretion1449293concretion
condition12411163con_dition
conductions1649663conductions
confecting18310553confecting
confectioner1964143confectioner
confession15126503confession
conflation15412083conflation
confliction1845233confliction
congelation14410343congelation
congestions1449313congestions
conjunction2245623conjunction
connation11314263con_nation
connecting15310383connecting
connectional1646723connectional
connective1749253connective
connector1347923connect_or
connexion1874603conne_xion
conniption1446273conniption
consecration1649783consecration
consecutions1647043consecutions
contentions13412093contentions
contortion1248663contortion
contraction15411243contraction
contrition12411413contrition
convect143114483convect___
convected1738783convect_ed
convectors1768313convectors
convects153410993convect__s
conventing16311543conventing
conventional1757163conventional
conversation1747803conversation
conversions1648273conversions
converting16313133converting
convertor1448783convert_or
convicting1847583convicting
convocations1947363convocations
convolution1645123convolution
convulsion1544433convulsion
corrections1548863corrections
evection131910833__evection
infection14410473_infection
injection1838653_injection
invention1248333_invention
nonaction1149443non_action
nonelection1347203nonelection
nonfiction1546303nonfiction
nonvector1445793nonvect_or
objection2045093_objection
reconnection1655993reconnection
reconviction1955083reconviction

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 Filter1786911406030.310576422.6
2DLD Change Limit140603867.70318253.0
3Display Results86860.0461869.6
 (SQL Overall)178691868.05922172.9
 
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.