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

91 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
revanches174625(None) 
revanche1645001revanche_
ranches123620112r__anches
reaches123423202re_a_ches
rebranches1745192rebranches
relaunches1543442relaunches
rematches1636652rematches
repatches1636712repatches
revanchism2052352revanchism
revanchist1853592revanchist
advances1445613advanc_es
beaches144120653be_a_ches
benches143918603be__nches
blanches153311603_blanches
branches153613803_branches
breaches153714123bre_a_ches
ceviches1834843cev_iches
cranches153114543_cranches
debauches17124063debauches
demarches1745913demarches
detaches1439653deta_ches
deviances1566493devianc_es
deviancies1644593deviancies
drenches14309803dre__nches
errancies1147963errancies
evanishes1545603_evanishes
evinces1237803_evinc_es
frenches163311633fre__nches
grievances1643223grievanc_es
kenches163912273ke__nches
leaches123319343le_a_ches
manches143818623__manches
menarches1646683menarches
peaches144120053pe_a_ches
penances12312443penanc_es
planches153111863_planches
preaches153214893pre_a_ches
prelaunches1852233prelaunches
prepunches1954013prepunches
rances84625443r__anc_es
ranched133113603r__anched
rancher123013633r__ancher
ranchers133311793r__anchers
ranchos123911393r__anchos
ratches123620463r__atches
raunches1368053r_aunches
reached134619083re_a_ched
reacher123718293re_a_cher
reachers133515723re_a_chers
rebranched1843673rebranched
recanes93222263recan__es
recencies13312253recencies
refaces123216743refa_c_es
refences13311843refenc_es
regencies1249283regencies
regnancies1345413regnancies
rehandles1345593rehandles
rehashes1436953reha_shes
relaces93420883rela_c_es
relaunched1642683relaunched
relevances1596113relevanc_es
relevancies1654333relevancies
reliances1139623relianc_es
rematched1745223rematched
repatched1745313repatched
researches1544293researches
retches123318513re__tches
reteaches1437123reteaches
retouches1445903retouches
retrenches1545903retrenches
revalues1137883reva_lues
revanchisms2152113revanchisms
revanchists1952213revanchists
revarnishes1742793revarnishes
revenges1238983reven_ges
revenues1138663reven_ues
revoices13278993revoic_es
rewashes1447033rewa_shes
roaches123616213r_oa_ches
romances12310793romanc_es
seances93015343se_anc_es
searches132112903se_arches
seviches1635803sev_iches
stanches132312793_stanches
teaches122718353te_a_ches
tenancies1149173tenancies
tenches123515523te__nches
tranches132915513_tranches
trenches133512603tre__nches
wenches152914133we__nches
wrenches163210233wre__nches

Search took 7 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 Filter1786911486410.423422437.4
2DLD Change Limit148641916.34323433.9
3Display Results91910.0461978.3
 (SQL Overall)178691916.81226231.8
 
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.