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

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
conventioneer1815262(None) 
conventioneers1982391conventioneers
confectioner1964143confection_er
conventicler1962813conventi_cler
convention15410563convention___
conventional1757163convention_al
conventions16410533convention__s
concessioner1653674concession_er
conditioner1474664con_dition_er
confectioners2073374confectioners
confectionery2362564confectionery
contention12412224contention___
contentions13412094contention__s
convection17411124convection___
convectional1947044convection_al
convections18411494convection__s
convenience1886444conven_ience_
conveniences1986314conven_iences
conventicle1854714conventi_cle_
conventiclers2072094conventiclers
conventicles1954164conventi_cles
conventing16311544conventi_n__g
conventionally2254984conventionally
cannoneer1143925can__n__oneer
coinventing1744545coinventi_n__g
coinventor1562975coinvent_o___r
concenter13312215concent____er
conception16410455conception___
conceptional1856915conception_al
conceptions17410595conception__s
concertgoer1672665concertgo__er
concessioners1753065concessioners
conditioned1564285con_dition_ed
conditioners1563925con_ditioners
confection17411185confection___
confectionary2353775confectionary
confectioneries2292095confectioneries
confections18411395confection__s
congestion1349045congestion___
congestions1449315congestion__s
connection14410535connection___
connectional1646725connection_al
connections15410705connection__s
consenter11312495consent____er
consenting13313225consenti_n__g
consentingly1854665consenti_ngly
contentedness1655385contentedness
contenting13313325contenti_n__g
contentious1347015contentio__us
contentiously1854175contentiously
contentiousness1763555contentiousness
continuer1148715co___nti_nuer
convecting18310435convecti_n__g
convective2049115convecti__ve_
convector1648085convect_o___r
convener132913165conve____n_er
conveniencies2074245conven_iencies
conveniency2154575conven_ien_cy
convenient1549055conven_i__ent
conveniently2054115conven_iently
convening15311195conven_i_n__g
convenor13307615conven__o___r
convented15410755convent____ed
conventionalism22133155conventionalism
conventionalist20123535conventionalist
conventionality2393045conventionality
conventionalize29102735conventionalize
conversion1548425conversion___
conversional1755145conversion_al
conversions1648275conversion__s
converter14311015convert____er
convertible1846235converti_ble_
convertibles1954625converti_bles
converting16313135converti_n__g
convertor1448785convert_o___r
conveyancer21123615conve__yancer
conviction1748185conviction___
convictions1848045conviction__s
convincer1645835conv___i_ncer
covenanter1563605co_ven__anter
electioneer1353865__electioneer
invention1248335_invention___
inventions1348315_invention__s
mentioner1146695___mention_er
potentiometer1761585po_tentiometer
unconventional1963125unconvention_al

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 Filter1786911247900.376475242.0
2DLD Change Limit124790868.32614988.0
3Display Results86860.0461869.6
 (SQL Overall)178691868.74820426.5
 
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.