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

97 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
upheaves164391(None) 
upheave1544021upheave_
upheaved1733761upheaved
upheaver1643441upheaver
upheavers1742591upheavers
heaves124120302__heaves
sheaves134412972_sheaves
unweaves1436142unweaves
upheaped1633642upheaped
upheaps1494232uphea_ps
upheaval1641582upheaval
upheavals1751072upheavals
apheses12610703aphe_ses
appeases1238663appeases
behaves15198523beh_aves
bereaves1338273bereaves
cleaves124111623_cleaves
deaves105319533__deaves
deleaves1248063deleaves
eaves85231993___eaves
ephebes1436153ephe_bes
greaves113311443_greaves
haves116034873__h_aves
heave114521813__heave_
heaved134717863__heaved
heaven123912603__heaven
heavens13439303__heavens
heaver124819673__heaver
heavers133717193__heavers
heavies132713873__heavies
helves124316063__helves
inweaves1445043inweaves
leaves94222383__leaves
paves104833923_p__aves
peaces106324083_p_eaces
peages94321853_p_eages
peases85229473_p_eases
peavey14398793_p_eavey
peaveys15324063_p_eaveys
peavies122213403_p_eavies
peeves113814873_p_eeves
pelves114514663_p_elves
phages125213513_ph_ages
phases114618403_ph_ases
phenates13611583_phenates
phrases12711463_phrases
pleases94515483_pleases
preaver121011613_preaver
preavers13910263_preavers
prepaves15189193_prepaves
reaves94127573__reaves
reweaves1436603reweaves
shaves125224933_sh_aves
sheave124514003_sheave_
sheaved143411633_sheaved
sheeves133911953_sheeves
shelves134112093_shelves
sleaves103813203_sleaves
sphenes123013163sphe_nes
spheres123114353sphe_res
thraves13469713_thraves
uneases73316263u_neases
unhealed121511073unhealed
unheated121514553unheated
unnerves1157273unnerves
unreeves11106163unreeves
unweave1336363unweave_
upases84112903up__ases
upbearer1243583upbearer
upbearers1343033upbearers
upbears1195423upbea_rs
upbeats1195733upbea_ts
upcurves1583153upcurves
updates10329793up_dates
updives1334713up_dives
upgazes1933573up_gazes
upgrades12216063upgrades
upheap13105213uphea__p
upheaving1843803upheaving
uphoards1443763uphoards
uphove1436133uph_ove_
uphroes1236303uph_roes
upleaped1334333upleaped
upleaps1185233uplea_ps
uprates93814863up_rates
upreaches1654633upreaches
upreared1137073upreared
uprears9107493uprea_rs
upscales12155993upscales
upstages11147373upstages
upstares10178583upstares
upstates10189643upstates
uptakes1336593up_takes
uptears9106453uptea_rs
ureases74416723u_reases
weaves123616373__weaves
wherves16548053_wherves

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 Filter1786911461620.423422437.4
2DLD Change Limit146162976.70021815.2
3Display Results97970.0332939.4
 (SQL Overall)178691977.15624970.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.