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

55 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
ricocheting195237(None) 
ricochetting2051741ricochetting
cacheting1737153__cacheting
crocheting1844703_crocheting
racheting1537793r__acheting
ratcheting1643783r_atcheting
richening1546223ri__chening
ricochet1547083ricochet___
ricocheted1852373ricochet_ed
ricochets1643413ricochet__s
ricochetted1951823ricochetted
rocketing1666973r__ocketing
accreting1446334_ac_creting
cockering1839694__cockering
cocreating15310294__cocreating
cohering142413834__co_hering
colleting12311064__colleting
competing163712464__competing
concreting1539874__concreting
corseting12312174__corseting
coshering15510024__coshering
cosseting1239544__cosseting
coveting141912304__co_veting
cricketing1944034cri__cketing
decocting1538124decoc__ting
docketing1785414__docketing
lichening1545674li__chening
lichting14268514li__ch_ting
ochering14219394___ochering
picketing1835684pi__cketing
picoting1338884pico___ting
pocketing1875854__pocketing
racketing1647874r__acketing
recarpeting1674364recarpeting
rechewing1836494r__echewing
recoating121317464reco__ating
recocking18138374recoc__king
recollecting1764084recollecting
recomputing1844344recomputing
reconnecting1745354reconnecting
reconvening1746294reconvening
reconverting1876404reconverting
reconveying2044634reconveying
recounting1339194reco_unting
recovering1647374reco_vering
rejacketing2542414rejacketing
relocating13310874reloc_ating
righting132610854ri__gh_ting
rioting82716394ri_o___ting
riposting1236064ripo__sting
riveting12139444ri___veting
roqueting1944604r__oqueting
socketing1666384__socketing
ticketing1635634ti__cketing
tochering1537154__tochering

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.453394461.4
2DLD Change Limit148819558.67317158.9
3Display Results55550.0301833.3
 (SQL Overall)178691559.15619516.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.