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

86 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
upsurged1212404(None) 
upsurge10134331upsurge_
upsurges11144801upsurges
purged104918262_p_urged
resurged1038622resurged
splurged1243912splurged
surged84118882__surged
unpurged1236292unpurged
unurged939142u_nurged
upcurled1393782upcurled
upcurved16142992upcurved
upstaged12135242upstaged
upturned11214012upturned
usurped1035152u_surped
assuaged1044383assuaged
assured858373assur_ed
ensured83512943ensur_ed
gurged95513363__gurged
insured83714253insur_ed
parged104922033_p_arged
plugged12408033_plugged
plunged11439513_plunged
poured95116743_pour_ed
pugged114314523_p_ugged
pureed95017803_p_ureed
purge85324603_p_urge_
purger94717233_p_urger
purges94421763_p_urges
purled94520743_p_urled
purred94218073_p_urred
pursed95220883_p_ursed
resurge839073resurge_
resurges9310123resurges
ruptured1144683ruptur_ed
scourged1234573scourged
serged84118763__serged
sparged113512753sp_arged
splurge1044753splurge_
splurger1143803splurger
splurges1145153splurges
spurge93711323sp_urge_
spurges104111653sp_urges
spurned10339263sp_urned
spurred103610613sp_urred
spurted103111973sp_urted
surfed103814463__surfed
surge65027693__surge_
surger74320093__surger
surges73924593__surges
unburied11208513unburied
unburned11227413unburned
uncurbed1346903uncurbed
uncured10513233uncur_ed
uncurled1168963uncurled
uncursed1148963uncursed
unforged13238623unforged
unfurled1277203unfurled
unjudged1843453unjudged
unplugged1442733unplugged
unserved12410233unserved
unsorted9312513unsorted
unsourced1244823unsourced
unsoured9310053unsour_ed
unsuited9310783unsuited
unsure62815413unsur_e_
unturned9228563unturned
upcurve1463273upcurve_
upcurves1583153upcurves
updarted1244313updarted
updried11226473up_dried
upgirded1342333upgirded
uprushed14234473uprushed
upscaled13144873upscaled
upsized19246243ups_ized
upsoared11154353upsoared
upstage10167443upstage_
upstager11164633upstager
upstages11147373upstages
upstared11156573upstared
upstarted1244213upstarted
upstirred1241823upstirred
upsurging1343353upsurging
urged75316033___urged
usurer638103u_sur_er
usuries7510633u_suries
usurper934353u_surper

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162866.54622328.4
3Display Results86860.0332606.1
 (SQL Overall)178691866.73526531.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.