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

43 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
captaincies175265(None) 
chaplaincies2151312chaplaincies
capsaicins1672913capsai_cins
captaincy1842013captainc__y
captained1446193captain__ed
captaining1546073captain_ing
captains121810573captain___s
captainships2162553captainships
certainties1353763certainties
acutances1345764acuta_nc_es
blatancies1444384blata_ncies
cadencies1447324ca__dencies
cantatrices1553444cantatrices
canticles1339184cant_i_cles
capacities1647694cap_acities
capriccios1551944cap_riccios
caprices1439894cap_ri_c_es
capsaicin1553044capsai_ci_n
capsicins1545174cap_si_cins
captain112111064captain____
captainship2062654captainship
captans111612054capta_n___s
captivates1745494capt_ivates
captives1538624capt_i__ves
captivities1845944captivities
chieftaincies2361024chieftaincies
compliancies2053484compliancies
constancies1546644consta_ncies
coprinces1547484cop_rinc_es
instancies1246614insta_ncies
laitances1145614laita_nc_es
latencies1147774la_t_encies
painches1588914__p_ainches
papacies1439484pap_a__cies
patencies1349174pa_t_encies
pliancies1346674__pliancies
radiancies1345284radia_ncies
rampancies1644044rampa_ncies
ratanies8312924ra_ta_n_ies
sapiencies1445124sap_iencies
vacancies1645494va_ca_ncies
vagrancies1644174vagra_ncies
valiancies1545284valia_ncies

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 Filter1786911488190.423422437.4
2DLD Change Limit148819438.95316622.2
3Display Results43430.0162687.5
 (SQL Overall)178691439.39219025.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.