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

196 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
presager113844(None) 
presage10312291presage_
presaged1238801presaged
presagers1236941presagers
presages11312201presages
preaged11612332pre_aged
preaver121011612pre_aver
prefacer1537982prefacer
preparer12169642preparer
presale9416352presale_
presales10315262presales
presider11410422presider
presser93717622pres_ser
prester93519622pres_ter
presumer1247582presumer
breaker133912923bre_aker
brewage1347183brewage_
brewages1436383brewages
creamer113714093cre_amer
creaser94415743cre_aser
creasier103210203creasier
crusader1144273crusader
dreamer104110843dre_amer
dredger10347453dre_dger
dressage1044253dressage_
dressages1144153dressages
dresser83611953dres_ser
dressier956863dressier
eager65526973__e_ager
frescoer1345983frescoer
fresher132612643fres_her
greaser83913083gre_aser
greasier9298083greasier
greater84416493gre_ater
massager1136873massager
meager94515203_me_ager
packager17136153packager
pager84728203p___ager
passage1039803passage_
passaged1236243passaged
passages1139513passages
peage84723573p_e_age_
peages94321853p_e_ages
pedaler103410693p_edaler
peerage1089803peerage_
peerages1189893peerages
pelage9515363p_elage_
pelages10714613p_elages
persuader1244263persuader
pervader1444863pervader
pesade9311103p_esade_
pesades10310903p_esades
peskier13319113p_eskier
pester84827593p_es_ter
pestier94317403p_estier
phreaker1735053phre_aker
pillager11278553pillager
pleader103511753ple_ader
pleaser93912343ple_aser
pleater93916333ple_ater
pledger11359173ple_dger
prater84825353pr__ater
prayer114815293pr__ayer
preacher153211373preacher
prealter1048863prealter
preavers13910263pre_avers
prebade12310283prebade_
prebake1539093prebake_
prebaked1737173prebaked
prebakes1639013prebakes
precancer1547093precancer
preciser123411663preciser
predate10616893predate_
predated12513273predated
predates11615813predates
predator11310053predator
preener93114833pre_ener
preface14510923preface_
prefaced1638423prefaced
prefacers1636293prefacers
prefaces15311063prefaces
prefade1339013prefade_
prefaded1537823prefaded
prefades1439533prefades
prefer113813203pre__fer
pregame1239553pregame_
pregames1339003pregames
preggers12236833pre_ggers
preheater1448913preheater
prejudger2042553prejudger
prelate9519693prelate_
prelates10418573prelates
preluder1135733preluder
premade12311443premade_
premerger1444903premerger
premier113515633pre_mier
prename11412643prename_
prenames12311643prenames
preorder1136463preorder
prepare111913623prepare_
prepared132210873prepared
preparers13197673preparers
prepares122014163prepares
prepave14228873prepave_
prepaved16177233prepaved
prepaves15189193prepaves
preppier1156643preppier
prerace11414123prerace_
presa74319043presa___
presageful1651633presageful
presaging1339393presaging
presbyter1643733presbyter
prescore124812373prescore
prese75228383pres__e_
presenter11311643presenter
preserver14127013preserver
preset84430983pres__et
preshape1537533preshape_
preshaped1745523preshaped
preshapes1667093preshapes
preside10715613preside_
presided12410553presided
presiders1248213presiders
presides11414913presides
presleep1244493presleep
presoaked1635653presoaked
pressed103317313pres_sed
pressers103215023pres_sers
presses93523153pres_ses
pressmen1238833pressmen
pressor93512883pres_sor
pressure1039773pressure
presters103419003pres_ters
prestige11310733prestige_
prestiges12310593prestiges
prestore104217353prestore
presume11310303presume_
presumed1337973presumed
presumers1336373presumers
presumes1239843presumes
presurgery1642783presurgery
pretape113511623pretape_
pretaped13339133pretaped
pretapes122811533pretapes
prettier1069043prettier
prevailer1445153prevailer
prewar114712583prewa__r
preyer114413733pre__yer
primage12169143primage_
primages13159273primages
prisoner1048573prisoner
prissier10157873prissier
privater13158533privater
profaner13197943profaner
progger11319373pr_ogger
prosateur1143583prosateur
proser84223463pros__er
prosier93817493pros_ier
prosper114012193pros_per
ravager1136563_ravager
reader73628293_re_ader
realer63528593_re_aler
reamer84325213_re_amer
reaper84223143_re_aper
rearer64928913_re_arer
reaver94524733_re_aver
rebater93517913_rebater
regaler83814623_regaler
relater73723143_relater
relaxer143410223_relaxer
remaker133813173_remaker
reneger8299493_reneger
repaper11310023_repaper
resale64025543_resale_
resales74724903_resales
resawed113111183_resawed
rescuer939033_rescuer
reshaper1336913_reshaper
resider84615803_resider
resigner937793_resigner
restage83316193_restage_
restaged103011863_restaged
restages92815773_restages
rester63832433_res_ter
resumer9410113_resumer
retaker113714313_retaker
sager65432053___sager
spreader1137483spre_ader
teenager9115293teenager
treader84113833tre_ader
treater74219833tre_ater
tressier847963tressier
uneager839753une_ager
wreaker143610043wre_aker
wrester102812413wres_ter
wrestler11306993wrestler

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.420425454.8
2DLD Change Limit1461621967.42319690.4
3Display Results1961960.0762578.9
 (SQL Overall)1786911967.91922564.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.