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

89 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
convinces164783(None) 
convince1547361convince_
convinced1745361convinced
convincer1645831convincer
convincers1745061convincers
confines13315652confin_es
coniines10415362coniin_es
conines93827792con_in_es
continues11310992continues
convenes132916912conven_es
convicts15337712convi_cts
coprinces1547482coprinces
reconvinces1844952reconvinces
bovines12412663bo_vin_es
canines93724033can_in_es
cervices1537133cervi_ces
cocaines121314443cocain_es
codeines113114523codein_es
codices12512583co_di_ces
codpieces1643803codpieces
collinses1138283collinses
combines142814623combin_es
commences17139573commences
condenses12710133condenses
condones112817393condon_es
conduces13129773con_duces
confidences1946633confidences
confides14310573confi_des
confine12315583confin_e_
confined14310403confin_ed
confiner13311193confin_er
confiners1439953confiners
conics103920593con_i_c_s
conies84338593con_i__es
coniine9316803coniin_e_
conine84528553con_in_e_
conins84327233con_in__s
conioses10313313con_ioses
conjuncts2043643conjuncts
connivances1854183connivances
connives1339723conni_ves
conominees1445923conominees
consciences1447023consciences
consignees1345223consignees
continences1588583continences
continue10311123continue_
continued1248483continued
continuer1148713continuer
continuers1247943continuers
continuos1147003continuos
convects153410993conv_ects
convene123314323conven_e_
convened143412223conven_ed
convener132913163conven_er
conveners142911443conveners
conveniences1986313conveniences
convenors14277633convenors
convented15410753convented
convents132614603conven_ts
converges1538373converges
converses14311163converses
convexes20278273conv_exes
conveyances2185203conveyances
convict143410983convi_c_t
convicted1746313convicted
convincing1845343convincing
convokes17247703conv_okes
convolves1745323convolves
convulses1445503convulses
coppices1638243coppi_ces
coprince1447093coprince_
cornices12713283corni_ces
cortices12615003corti_ces
corvinas13238003corvin_as
corvine122113643corvin_e_
cosines94122673co_sin_es
covings134511243co_vin_gs
covins114618063co_vin__s
crevices1536713crevi_ces
evinces1237803__evinces
nondances1247803nondances
novices1238223no_vi_ces
ovines94614343_o_vin_es
provinces1646853provinces
reconvince1744863reconvince_
reconvinced1953803reconvinced
sonances10310263son_ances
tontines82114733tontin_es
unconvinced1953003unconvinced

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 Filter1786911486410.1731032896.0
2DLD Change Limit148641899.47015696.0
3Display Results89890.0761171.1
 (SQL Overall)178691899.71918385.7
 
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.