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

54 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
gearchanges185229(None) 
gearchange1752231gearchange_
archangel1544313__archangel
archangels1643283__archangels
exchanges22124613_e_xchanges
gearcases1254693gearc_a_ses
rearranges1145113rear_ranges
rechanges1568183re__changes
archaises1448404__archaises
archaizes2346444__archaizes
archines133815254__archin_es
archings14499864__arching_s
arranges939414__ar_ranges
bacchantes1944424_bacchantes
barchans1588684_barchan__s
bechances1847614be__chances
blancmanges1851044blancmanges
changes134517584____changes
deranges1039974de_r__anges
earphones1448394_earphon_es
exarchates2243964exarcha_tes
exchange21124324_e_xchange_
exchanged23113674_e_xchanged
exchanger22123974_e_xchanger
exchangers23103204_e_xchangers
garages9314114g_ar__a_ges
garbages1238184g_ar_ba_ges
gearcase1154454gearc_a_se_
gearings10359504gear__ing_s
granges93516524g__r__anges
guacharoes1652314gua_charoes
guaranies10127124guar__anies
interchanges1894264interchanges
leachates1446664lea_cha_tes
marchpanes1943604_marchpan_es
merchanted1844484me_rchanted
merchants1646224me_rchan_ts
overcharges2044514overcharges
perchance1866394pe_rchance_
prearranges1453044prear_ranges
reactances1446144rea_ctances
rearrange1045034rear_range_
rearranged1244104rear_ranged
rechange1458184re__change_
rechanged1646854re__changed
recharges1586954re__charges
repechages1843274repecha_ges
searchable1744144searchable_
searches132112904search___es
searching1538344searching__
searchingly2042844searchingly
shortchanges2151624shortchanges
surcharges1644014_surcharges
teachings15296554tea_ching_s

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 Limit148819549.36015899.5
3Display Results54540.0301800.0
 (SQL Overall)178691549.81318209.6
 
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.