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

168 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
persists104918(None) 
persist9315851persist_
desists83611722de_sists
permits11314002permi_ts
persalts1038192persalts
persisted1247142persisted
persister1146832persister
persisters1246272persisters
presifts1366592presifts
purists94014072pur_ists
resists74414922re_sists
verists103613672ver_ists
aorists74215833aor_ists
artists74215593_artists
assists738473_assists
aurists74615783aur_ists
bassists1037183bassists
bedsits1037563bedsi_ts
bemists113410703be_mists
cellists1038563cellists
ceramists1346723ceramists
cercises12410933cercises
cerises94722253cer_ises
consists10310593consists
deists74916433de__ists
delists84414173de_lists
dentists939263dentists
dermises112512023dermises
derrises93012783derrises
desist74818813de_sist_
egoists887073_egoists
enlists749393_enlists
epeeists1044793epeeists
exists134710913_e_xists
feists94915313fe__ists
feudists1244463feudists
grists74716483_gr_ists
harpists1338103harpists
heists96814633he__ists
heriots10312063her_iots
hermits12312143hermi_ts
heroisms1338693heroisms
hornists11208833hornists
insists739083_insists
jurists14409123jur_ists
kermises14248313kermises
leftists11235513leftists
legists899593le_gists
lyrists1036963lyr_ists
merises93421423mer_ises
merisis93213173mer_isis
merits8320873mer_i_ts
metrists1039853metrists
narcists1078113narcists
palmists12268813palmists
papists112110453p_apists
parises94827183par_ises
parodists1248513parodists
parvises133911913parvises
peasants1038263peasants
peewits12105873peewi_ts
peises84125043pe__ises
pelisses1048483pelisses
peltasts1035703peltasts
pelvises1337273pelvises
penises9318193pe_nises
pensils92811593pensi_ls
pensions10311693pensions
peonisms1238443peonisms
pepsines1239883pepsines
pepsins11310433pepsi_ns
percents122713373percents
percepts14247643percepts
percuss1137163percus_s
pereions10310853pereions
perfects15107353perfects
perfuses1358663perfuses
periapts1237273periapts
peridots1138323peridots
perils84121853per_i_ls
periods10312243per_iods
peris75537073per_i__s
perish114619063per_is_h
perishes13313753perishes
periti8319953per_i_ti
peritus9311803per_itus
perkiest143313243perkiest_
perkish16258823perkis_h
perlite9317323perli_te
perlites10316363perlites
permit10321683permi_t_
perpents122312043perpents
perries93226603perri_es
persalt9315413persalt_
perses85428063per__ses
persistent1246033persistent
persisting1346653persisting
personas102511883personas
persons93717013pers_ons
perspires1346663perspires
pertest9317043pertest_
peruses94018163per_uses
perverts1337533perverts
pervious1337543pervious
pessimists1453863pessimists
pests75933273pe___sts
pewits112810683pe_wi_ts
pianists1049013pianists
pietists1038323pietists
plenists1038253plenists
pollists10910823pollists
poloists10910523poloists
porisms113713453por_isms
posits85718713p_osi_ts
praises94121103p_raises
precasts1239453precasts
precises123218333precises
predicts1339613predicts
preexists1844733preexists
premises123018273premises
premiss113513813premis_s
presents103315643presents
presets94216423pres_ets
presides11414913presides
presift12312223presift_
presorts105311683presorts
presses93523153pres_ses
prests84021263p_r_ests
pretests10310013pretests
previses133814283previses
previsits1446793previsits
priests93810863p_riests
prints84320103p_r_ints
prises84133173p_r_ises
prisms104915503p_r_isms
priss74623893p_r_is_s
prisses94816713p_risses
prosaists1157503prosaists
protists10313363protists
purisms114110833pur_isms
purist85525053pur_ist_
pursiest102812123pursiest_
pursuits1045043pursuits
pyrosises1457583pyrosises
querists1736543quer_ists
realists83014843realists
relists73817053re_lists
reraises8415643reraises
rerises73525883rer_ises
resifts10378703re_sifts
resist64524533re_sist_
resits64725563re_si_ts
retwists1135603retwists
revuists1135153revuists
sexists14267673se_xists
subsists1037993subsists
tennists8297793tennists
territs72714503terri_ts
tersest71713993tersest_
verdicts1446013verdicts
verisms123011253ver_isms
verist93823893ver_ist_
versants1137783versants
versets103913103vers_ets
versines112213823versines
versions11310353versions
versts93914733ver__sts
wrists95415643_wr_ists

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.406440125.6
2DLD Change Limit1461621686.98620922.1
3Display Results1681680.0762210.5
 (SQL Overall)1786911687.46823927.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.