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

33 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
carmagnoles165169(None) 
carmagnole1551711carmagnole_
caracoles13310073car_a_coles
carbazoles2343593carba_zoles
armagnacs1452034_armagn_acs
armholes1347384_arm__holes
barcaroles1443804barca_roles
camisoles1345584ca_m_isoles
campaniles1644114ca_mpaniles
caracole12310354car_a_cole_
caracoled1445984car_a_coled
caracoler1346424car_a_coler
caracolers1445134car_a_colers
caracols12310414car_a_col_s
carambolas1643374car_ambolas
caravelles1544894car_avelles
carbachols1942784carbachol_s
carbazole2243774carba_zole_
carbinols1346114car_binol_s
carbuncles1643454car_buncles
cargoes104415224car__g_o_es
carioles10817074car___ioles
carmines123617864carm_in__es
carnages11312214carnag___es
carrioles1169474car__rioles
cartages11313314cartag___es
caruncles1345004car__uncles
carvacrols1752014carvacrol_s
crankles143510154c_r_a_nkles
crannoges1244244c_r_annoges
farandoles1462974far_andoles
farragoes1344634farrag_o_es
paragoges1347254par_ag_oges

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.436409841.7
2DLD Change Limit148819338.86016796.7
3Display Results33330.0162062.5
 (SQL Overall)178691339.31219189.3
 
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.