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

71 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
convertibles195462(None) 
convertible1846231convertible_
conventicles1954162conventicles
convertibly2155132convertibl_y
collectibles1883613collectibles
comestibles1753953co_mestibles
concertizes24158583concerti_zes
connectible1755253connectible_
conventicle1854713conventicle_
conventicler1962813conventicler
conventiclers2072093conventiclers
conversable1846353conversable_
convertibleness2262633convertibleness
convertiplanes21112123convertiplanes
inconvertible20103903inconvertible_
invertible1547503_invertible_
avertible1495234__avertible_
coercible1544874co__ercible_
collectables18103354collectables
collectible17104514collectible_
combustibles2061754combustibles
comestible1645424co_mestible_
compatibles19134144co_mpatibles
conceptacles1773794conceptacles
concertinas15107564concerti_nas
concertinos15158124concerti_nos
concertize23169354concerti_ze_
concertized25146364concerti_zed
concretizes24166004concreti_zes
condensible16134404condensible_
conductible1854464conductible_
conferrable1845824conferrable_
congeries12316404conger_i__es
connectable1745714connectable_
connectives1847504connecti_ves
conscribes1645194conscr_ib_es
constables1446734con__stables
contemptible2053274contemptible_
contestable1546894contestable_
controvertible21101844controvertible_
convections18411494convecti_ons
convective2049114convecti_ve_
conventions16410534conventi_ons
conventuals1665174conventual_s
convergences20146254convergences
converges1538384conver___ges
conversances1975724conversances
converses14311164conver___ses
conversions1648274conversi_ons
convertaplanes21111764convertaplanes
converted15311564convert___ed
converter14311014convert___er
converters1539634convert__ers
convertibility2463274convertibility
converting16313134converti__ng
convertiplane20131834convertiplane
convertors1549134convert__ors
converts133213554convert____s
convexities2354564conve_xities
coverable1649104co_ver_able_
coversines15128634co_versi_nes
covertures1545464co_vert_ures
covetable1648164co_ve_table_
inconvertibly23113454inconvertibl_y
nonconvertible21113124nonconvertible_
nonedibles1353674non_e_dibles
overtimes141511304_o_verti_mes
overtires121412374_o_verti_res
poverties1439514po_verti__es
reversibles1682854_reversibles
revertible1575194_revertible_

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 Filter1786911247900.390458182.1
2DLD Change Limit124790716.76618443.7
3Display Results71710.0461543.5
 (SQL Overall)178691717.20224811.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.