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
convertibles195461(None) 
convertible1846201convertible_
conventicles1954152conventicles
convertibly2155112convertibl_y
collectibles1883603collectibles
comestibles1753943co_mestibles
concertizes24158583concerti_zes
connectible1755223connectible_
conventicle1854693conventicle_
conventicler1962803conventicler
conventiclers2072083conventiclers
conversable1846353conversable_
convertibleness2262633convertibleness
convertiplanes21112123convertiplanes
inconvertible20103883inconvertible_
invertible1547493_invertible_
avertible1495234__avertible_
coercible1544864co__ercible_
collectables18103354collectables
collectible17104484collectible_
combustibles2061744combustibles
comestible1645404co_mestible_
compatibles19134134co_mpatibles
conceptacles1773794conceptacles
concertinas15107524concerti_nas
concertinos15158104concerti_nos
concertize23169354concerti_ze_
concertized25146364concerti_zed
concretizes24166004concreti_zes
condensible16134374condensible_
conductible1854434conductible_
conferrable1845824conferrable_
congeries12316404conger_i__es
connectable1745694connectable_
connectives1847504connecti_ves
conscribes1645194conscr_ib_es
constables1446734con__stables
contemptible2053244contemptible_
contestable1546874contestable_
controvertible21101824controvertible_
convections18411484convecti_ons
convective2049104convecti_ve_
conventions16410534conventi_ons
conventuals1665154conventual_s
convergences20146254convergences
converges1538374conver___ges
conversances1975714conversances
converses14311164conver___ses
conversions1648264conversi_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_
inconvertibly23113444inconvertibl_y
nonconvertible21113094nonconvertible_
nonedibles1353654non_e_dibles
overtimes141511304_o_verti_mes
overtires121412374_o_verti_res
poverties1439514po_verti__es
reversibles1682854_reversibles
revertible1575194_revertible_

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 Filter1786911247900.1431249587.4
2DLD Change Limit124790719.32613380.9
3Display Results71710.0461543.5
 (SQL Overall)178691719.51518779.9
 
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.