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

45 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
caracoling154563(None) 
caracolling1643031caracolling
caroling113317002car__oling
carpooling1545022carpooling
crackling18157002c_rackling
arecoline1147103_arecoline
caballing1436883caba_lling
cackling172610943c__ackling
cajoling18318423c__ajoling
canaling112016413cana__ling
canalling1239553cana_lling
canceling14310163ca_nceling
caprioling1544523caprioling
caracol11310423caracol___
caracole12310353caracol__e
caracoled1445983caracol_ed
caracoler1346413caracol_er
caracolers1445123caracolers
caracoles13310073caracol_es
caracolled1543013caracolled
caracols12310413caracol__s
caravaning1644423caravaning
carjacking2643543carjac_king
carling103727063car___ling
carolling1259413car_olling
caroming133312963car__oming
carroming1437683car_roming
cartoning12311113car_toning
cartooning1345883cartooning
cataloging1444953cataloging
catcalling1545123catcalling
charcoaling1953173char_coaling
circling1338423cir_c_ling
craaling112711353c_ra_aling
cracking174013903c_rac_king
cracklings19143523c_racklings
cradling122411453c_ra_dling
crankling16147293c_rankling
crawling143110513c_ra_wling
crayoning1535243c_rayoning
manacling1446283manac_ling
paragoning1445953paragoning
parceling1438443par_celing
paroling113316213par__oling
trachling1537823_trachling

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 Filter1786911406030.436409841.7
2DLD Change Limit140603456.76620780.8
3Display Results45450.0301500.0
 (SQL Overall)178691457.23224708.4
 
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.