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

131 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
presagers123694(None) 
presager1138441presager_
presages11312201presage_s
preavers13910262pre_avers
prefacers1636292prefacers
preggers12236832pre_ggers
preparers13197672preparers
presage10312292presage__
presaged1238812presage_d
presales10315262presale_s
presiders1248212presiders
pressers103215022pres_sers
presters103419002pres_ters
presumers1336372presumers
breakers143810973bre_akers
brewages1436383brewage_s
creamers124111313cre_amers
creasers103612843cre_asers
crusaders1243453crusaders
dreamers11369003dre_amers
dredgers11256093dre_dgers
dressages1144153dressage_s
dressers9359863dres_sers
eagers74523683__e_agers
frescoers1454563frescoers
greasers93410253gre_asers
massagers1245513massagers
packagers18144683packagers
pagers94423253p___agers
passages1139513passage_s
peages94321853p_e_age_s
pedalers11239393p_edalers
peerages1189893peerage_s
pelages10714613p_elage_s
persuaders1343353persuaders
pervaders1544433pervaders
pesades10310903p_esade_s
pesters93827093p_es_ters
phreakers1834673phre_akers
pillagers12276923pillagers
pleaders113210183ple_aders
pleasers104010293ple_asers
pleaters103613793ple_aters
pledgers12387643ple_dgers
praters94921653pr__aters
prayers124212853pr__ayers
preachers16339573preachers
preaged11612333pre_age_d
prealters1147773prealters
preaver121011613pre_aver_
prebakes1639013prebake_s
precancers1645253precancers
predates11615813predate_s
predators12310083predators
preeners102712813pre_eners
prefacer1537983prefacer_
prefaces15311063preface_s
prefades1439533prefade_s
prefers123713333pre__fers
pregames1339003pregame_s
preheaters1557193preheaters
prejudgers2142193prejudgers
prelates10418573prelate_s
preluders1234423preluders
premiers122911653pre_miers
prenames12311643prename_s
preorders1235403preorders
preparer12169643preparer_
prepares122014163prepare_s
prepaves15189193prepave_s
presageful1651633presageful
presaging1339393presaging
presale9416353presale__
presbyters1743183presbyters
prescores133912173prescores
presenters1239863presenters
preservers15115693preservers
presets94216423pres__ets
preshapes1667093preshape_s
presider11410423presider_
presides11414913preside_s
presser93717623pres_ser_
presses93523153pres_se_s
pressors103212693pres_sors
pressures1149063pressures
prester93519623pres_ter_
prestiges12310593prestige_s
prestores114716083prestores
prestress1138133prestress
presumer1247583presumer_
presumes1239843presume_s
presurgery1642783presurgery
pretapes122811533pretape_s
prevailers15123833prevailers
preyers124412363pre__yers
primages13159273primage_s
prisoners1147373prisoners
profaners14256213profaners
proggers12258163pr_oggers
prosateurs1243063prosateurs
prosers94219643pros__ers
prospers123012263pros_pers
ravagers1235583_ravagers
readers83823773_re_aders
reamers94221083_re_amers
reapers93520453_re_apers
rearers74323563_re_arers
reavers108320743_re_avers
rebaters103413943_rebaters
regalers94311133_regalers
relaters83218153_relaters
relaxers15298263_relaxers
remakers143811303_remakers
renegers9248793_renegers
repapers1258833_repapers
resales74724903_resale_s
rescuers1037363_rescuers
reshapers1435493_reshapers
residers93311883_residers
resigners1036863_resigners
restages92815773_restage_s
resters74130403_res_ters
resumers1038083_resumers
retakers123511133_retakers
spreaders1236503spre_aders
teenagers10114493teenagers
treaders93311843tre_aders
treaters83615853tre_aters
wreakers15328423wre_akers
wresters112711733wres_ters
wrestlers12306103wrestlers

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 Filter1786911486410.453394461.4
2DLD Change Limit1486411316.67322275.0
3Display Results1311310.0602183.3
 (SQL Overall)1786911317.18624866.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.