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 “presorting” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

145 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
presorting133998(None) 
resorting10614611_resorting
preforming1846232preforming
prescoring1547432prescor_ing
presenting131013022presenting
preserving1637362preserving
presetting131010832presetting
presifting1638082presifting
presoaking1736252presoaking
presolving1644362presolving
prestoring13310302prestor_ing
preworking2044232preworking
reporting12513902_reporting
resorbing1269352_resorbing
retorting10613272_retorting
assorting1037303_assorting
besotting12256873_besotting
consorting13410743consorting
creosoting1343793creosoting
cresting114017043cres__ting
dehorting1447213_dehorting
deporting1369593_deporting
deserting11713143_deserting
desorbing1346363_desorbing
escorting1237713__escorting
missorting1347123missorting
perforating1747023perforating
performing1844943performing
perorating13313133p_erorating
persisting1346653persisting
personating1447673personating
perverting1646623perverting
porting103021783p___orting
preabsorbing1951973preabsorbing
preacting142412533pre_acting
preadopting1743993preadopting
prearming14139223pre_arming
preboarding1744273preboarding
preboiling1546403preboiling
prebooking1944073prebooking
precasting15169833precasting
precenting151012153precenting
precoding15109733preco_ding
precooking1945043precooking
precooling1545963precooling
precuring1439423precur_ing
precutting1546423precutting
predating13514653pre_dating
predicting1649873predicting
predrying1645343pre_drying
preediting1447933preediting
preempting1745393preempting
preferring1645623preferring
prefiring1559073prefir_ing
preheating16310723preheating
prehiring1548383prehir_ing
preinserting1544173preinserting
prelecting15310163prelecting
preloading1446583preloading
prelocating1647413prelocating
premolding1644673premolding
preparing14311643prepar_ing
prepasting15168883prepasting
preportion1448873preportion
preportions1548263preportions
presaging1339393pres_aging
prescribing1844553prescribing
preselling1338693preselling
presettling1444453presettling
preshaping1845423preshaping
preshowing1944473preshowing
preshrink1844773preshr_ink
presiding13510903pres_iding
preslicing1546363preslicing
presong1039843preso___ng
presort95219543presort___
presorted1239453presort_ed
presorts105311683presort__s
pressing112516443pres__sing
pressuring1346513pressuring
presuming1437663pres_uming
pretasting13239283pretasting
pretesting131810683pretesting
pretexting20206973pretexting
preuniting1347303preuniting
preventing161210263preventing
prewarming18145173prewarming
prewarning16135193prewarning
prewiring1547893prewir_ing
prewriting1647243prewriting
priesting1239483pries__ting
prisoning1237643priso_ning
promoting1439923promo_ting
prorating12314283pr__orating
prosecting15189813prosecting
prostrating1449393prostrating
purporting1543793purporting
reassorting1245023_reassorting
rebooting12139023_rebooting
reboring11312783_rebor_ing
recoating121317463_recoating
recording131311623_recording
recorking16149643_recorking
reforging1437663_reforging
reforming1538563_reforming
regorging1236823_regorging
repotting12511123_repotting
rerouting10311873_rerouting
rescoring12310603_rescor_ing
reseating102421533_reseating
resecting122816483_resecting
resenting102619293_resenting
reserving131110643_reserving
resetting102816293_resetting
reshooting1436223_reshooting
resifting133512093_resifting
resisting103215313_resisting
resiting93521123_res_iting
resitting103414873_resitting
reslating102516993_reslating
resoaking1439373_resoaking
resodding1237203_resodding
resoling92916303_reso_ling
resolving1337743_resolving
resonating11311263_resonating
resorcin1046823_resorcin_
resorcins1146983_resorcins
resowing123111523_reso_wing
respiting121912863_respiting
respotting1347113_respotting
respring111614063_respr_ing
restarting11310663_restarting
restating102319413_restating
resting85031183_res__ting
restoring10314613_restor_ing
restring91518783_restr_ing
resulting10311083_resulting
resurging1138613_resurging
reverting132315133_reverting
revolting1339633_revolting
revoting12312033_revo_ting
rewording14158543_rewording
reworking17136873_reworking
sorting83221813___sorting
wresting123811833wres__ting

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 Filter1786911406030.423422437.4
2DLD Change Limit1406031456.73320882.7
3Display Results1451450.0761907.9
 (SQL Overall)1786911457.23224708.4
 
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.