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

189 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
presift1231222(None) 
presifts1366591presifts
resift94017721_resift
persist9315852persist
predict12315322predict
prelife1279942prelife
premixt183510662premixt
preriot9316412preriot
present94022732present
preset84430982pres_et
preside10715612preside
presifted1536872presifted
presort95219542presort
prest75736352pres__t
prosit85124592prosi_t
resifts10378702_resifts
resist64524532_resist
resit54241042_resi_t
credit9315193credi_t
cresset93319943cresset
crest74632693cres__t
desist74818813_desist
drest65530343dres__t
drift95722843dr__ift
eyelift1396383eyelift
freshet133416643freshet
grift95924463gr__ift
paresis93315093paresi_s
peewit111110903peewi_t
permit10321683permi_t
persalt9315413persalt
persists1049183persists
pest65555293p_es__t
petit74332653p_eti_t
pewit104622793p_ewi_t
pietist9414033pietist
plenist9314333plenist
poesies93217403poesies
posit75833333p_osi_t
preact103220393pre_act
prebid113512843prebi_d
prebids12399883prebids
prebill1138803prebill
prebind123810643prebind
prebirth1543463prebirth
prebuilt1247033prebuilt
precast11314853precast
precent113520263precent
precept133112513precept
precinct1459423precinct
precipe133012123precipe
precis103416703preci_s
precise113518173precise
precut102016533pre_cut
predial103815413predial
predicts1339613predicts
predive13511083predive
predraft1447593predraft
preedit10512463preedit
preeing103817673preeing
preempt1337723preempt
preexist1747963preexist
prefect141011073prefect
prefight1746393prefight
prefile123413183prefile
prefire124012813prefire
prefix18356853prefi_x
preheat12413893preheat
prelect111013833prelect
prelim10311423preli_m
prelimit1259123prelimit
prelims1139823prelims
premeet11615153premeet
premie103617993premi_e
premier113515633premier
premies113823063premies
premise113818553premise
premiss113513813premiss
premium13310363premium
premix173710333premi_x
premolt11312073premolt
prepill1147583prepill
preprint12314183preprint
presa74319043pres__a
presage10312293presage
presale9416353presale
prescient13411323prescient
prescind1338393prescind
prescript1547033prescript
prese75228383pres__e
presell939303presell
presents103315643presents
presets94216423presets
preship1439793preship
preships1539313preships
preshow15237413preshow
presided12410553presided
president12410993president
presider11410423presider
presides11414913presides
presidia1147273presidia
presidio1146153presidio
presifting1638083presifting
preslice1258623preslice
presoak1348453presoak
presold1059603presold
presong1039843presong
presorts105311683presorts
presplit1247753presplit
press75425953pres__s
pressed103317313pressed
presser93717623presser
presses93523153presses
pressing112516443pressing
pressor93512883pressor
prester93519623prester
prestige11310733prestige
presto84216203pres_to
prestos93716083prestos
prests84021263pres_ts
presume11310303presume
pretest9517633pretest
pretext1639663pretext
prettify1644343prettify
prevent124016553prevent
preview1536473preview
previse123713793previse
previsit13410073previsit
prewire124311143prewire
prexies163415003prexies
preying133114553preying
priest84125423pries__t
print74837463pr__int
prising103321453prising
probit103218353probi_t
profit113016273profi_t
prosaist10611583prosaist
prosect11313393prosect
prosier93817483prosier
prosiest10416523prosiest
prosily12611633prosily
prosing103319383prosing
prost75434103pros__t
protist9320223protist
purest84021933pures__t
recit75235103_reci_t
redipt94116743_redipt
redshift1544623_redshift
refit84230063_refi_t
reft75141273_re__ft
regilt71217493_regilt
reif76937653_re_if_
reifs84819093_re_ifs
reify114814973_re_ify
relict83623903_relict
relist64628413_relist
relit55340683_reli_t
remint85329983_remint
remit75737223_remi_t
remixt155014853_remixt
resat55139683_res_at
reseat64131493_reseat
resect84424703_resect
resent63833623_resent
reset55051863_res_et
reshot93519633_reshot
resid64124093_resi_d
reside74224933_reside
resids74219153_resids
resifted12310153_resifted
resight11510643_resight
resign74212583_resign
resile64627673_resile
resin54131053_resi_n
resins64528773_resins
resiny94617363_resiny
resists74414923_resists
resite64128453_resite
resits64725563_resits
resize154117723_resize
resort65728623_resort
respot83117633_respot
rest46459843_res__t
result6318223_result
retint65633443_retint
rift75642333_r__ift
sift710740663___sift
versify1636333versify
wrest84925433wres__t

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.406440125.6
2DLD Change Limit1340271895.96622465.1
3Display Results1891890.0633000.0
 (SQL Overall)1786911896.43527768.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.