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

80 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
upsurge1013433(None) 
upsurged12124041upsurged
upsurges11144801upsurges
purge85324602_p_urge
resurge839072resurge
splurge1044762splurge
spurge93711322sp_urge
surge65027692__surge
unsure62815412unsur_e
upcurve1463272upcurve
upstage10167442upstage
assuage835683assuage
assure6610773assur_e
cesurae937703cesurae
ensure63416003ensur_e
gurge75419783__gurge
insure63416603insur_e
parge85831853_p_arge
plunge93811053_plunge
pure65543333_p_ur_e
puree74632843_p_uree
purged104918263_p_urged
purger94717233_p_urger
purges94421763_p_urges
purse76028893_p_urse
rasure6311423rasur_e
resurged1038623resurged
resurges9310123resurges
rupture966163ruptur_e
sarge65531133__sarge
scourge1035653scourge
serge64727473__serge
sparge94216053sp_arge
splurged1243923splurged
splurger1143813splurger
splurges1145163splurges
splurgy1343023splurgy
spurges104111653sp_urges
sure45447413__sur_e
surged84118883__surged
surger74320093__surger
surges73924593__surges
surgy95118523__surgy
unpure82911533unpur_e
unpurged1236293unpurged
unsung736983unsung_
unurged939143u_nurged
upbore10247883upbor_e
upborne11255133upborne
upcurl1034963upcur_l
upcurled1393783upcurled
upcurls1143653upcurls
upcurved16142993upcurved
upcurves1583153upcurves
uphroe1136083up_hroe
upscale11136323upscale
upside9289803ups_ide
upsize17267303ups_ize
upslope1144173upslope
upstaged12135243upstaged
upstager11164633upstager
upstages11147373upstages
upstare9158683upstare
upstate91610493upstate
upstroke1443993upstroke
upsurging1343353upsurging
upswung1341783upswung_
uptore8279453uptor_e
upturn8286243uptur_n
upturned11214013upturned
upturns9264973upturns
urge54722423___urge
usage6410213u_s_age
usurer638103u_surer
usuries7510633u_suries
usurp7106903u_sur_p
usurped1035153u_surped
usurper934353u_surper
usurps8105073u_surps
usury887623u_sur_y

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 Filter1786911340270.390458182.1
2DLD Change Limit134027805.95322514.2
3Display Results80800.0332424.2
 (SQL Overall)178691806.37628025.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.