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

153 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
presifts136659(None) 
presift12312221presift_
resifts10378701_resifts
persists1049182persists
predicts1339612predicts
presents103315642presents
presets94216422pres_ets
presides11414912presides
presifted1536872presifted
presorts105311682presorts
prests84021262pres__ts
resift94017722_resift_
resists74414922_resists
resits64725562_resi_ts
credits1039973credi_ts
cressets10309103cressets
crests85218703cres__ts
desists83611723_desists
drifts10499893dr__ifts
eyelifts1462753eyelifts
freshets14298673freshets
grifts104511683gr__ifts
paresis93315093paresi__s
peewits12105873peewi_ts
permits11314003permi_ts
persalts1038193persalts
persist9315853persist_
pests75933273p_es__ts
pewits112810683p_ewi_ts
pietists1038323pietists
plenists1038253plenists
poesies93217403poesi_es
posits85718713p_osi_ts
preacts113211363pre_acts
prebids12399883prebi_ds
prebills1237293prebills
prebinds13357733prebinds
prebirth1543463prebirth
prebirths1642153prebirths
precasts1239453precasts
precents123015043precents
precepts14268893precepts
precincts1544993precincts
precious12310593precious
precipes143212213precipes
precis103416703preci__s
precises123218333precises
precuts111710473pre_cuts
predict12315323predict_
preedits1168763preedits
preempts1444543preempts
preexists1844733preexists
prefects1598133prefects
prefiles133113443prefiles
prefires134313283prefires
prefixes20389233prefixes
preheats1339413preheats
prelects1299723prelects
prelife1279943prelif_e
prelimits1366013prelimits
prelims1139823preli_ms
prelives13310383prelives
premiers122911653premiers
premies113823063premi_es
premises123018273premises
premiss113513813premi_ss
premiums1437533premiums
premixes193110083premixes
premixt183510663premixt_
preprints1347473preprints
preriot9316413preriot_
presages11312203presages
presales10315263presales
prescinds1444953prescinds
prescripts1644743prescripts
presells1058283presells
present94022733present_
preset84430983pres_et_
preships1539313preships
preshows16267023preshows
preside10715613presi_de
presided12410553presided
presidents1347023presidents
presider11410423presider
presiders1248213presiders
presidia1147273presidia
presidio1146153presidio
presidios1245773presidios
presifting1638083presifting
preslices1338213preslices
presoaks1436603presoaks
presort95219543presort_
press75425953pres___s
pressers103215023pressers
presses93523153pres_ses
pressings12269023pressings
pressors103212693pressors
prest75736353pres__t_
presters103419003presters
prestiges12310593prestiges
presto84216203pres__to
prestos93716083pres_tos
presumes1239843presumes
pretests10310013pretests
pretexts1735603pretexts
prevents133012293prevents
previews1634513previews
previous1337823previous
previses133814283previses
previsits1446793previsits
prewires133811013prewires
prexies163415003prexi_es
priests93810863pries__ts
prints84320103pr__ints
probits112712573probi_ts
profits122911243profi_ts
prosaists1157503prosaists
prosects1239473prosects
prosiest10416523prosiest
prosit85124593prosi_t_
protists10313363protists
recits83621353_reci_ts
redshifts1642573_redshifts
refits94017653_refi_ts
reifs84819093_re_if_s
relicts94414593_relicts
relists73817053_relists
remints95117293_remints
remits85622943_remi_ts
reseats74319583_reseats
resects94115593_resects
resents74221223_resents
resets65427613_res_ets
resides84523283_resides
resids74219153_resi_ds
resifted12310153_resifted
resights1246733_resights
resigns83910963_resigns
resiles74026543_resiles
resins64528773_resi_ns
resist64524533_resist_
resit54241043_resi_t_
resite64128453_resi_te
resites74027793_resites
resizes164216843_resizes
resorts74817193_resorts
respots92912763_respots
rests54935873_res__ts
results739833_results
retints74717013_retints
rifts85718643_r__ifts
sifts84918923___sifts
wrests95313083wres__ts

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.403443402.0
2DLD Change Limit1461621537.11020557.2
3Display Results1531530.0463326.1
 (SQL Overall)1786911537.55923639.5
 
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.