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 “preexist” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

85 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
preexist174796(None) 
preexists1844731preexists
preedit10512462preedi_t
preedits1168762preedits
preexisted2043782preexisted
breeziest2035063breeziest
careerist1148793careerist
coexist1638583_coexist
creepiest1337063creepiest
epeeist938863epee_ist
exist124618943___exist
freest95318283free__st
greediest1147553greediest
greenest9312623greenest
greeniest1039033greeniest
greenish1247073greenish
panelist10414503panelist
peevish1535783p_eevish
peewit111110903p_eewi_t
peewits12105873p_eewits
persist9315853p_ersist
pietist9414033p_ietist
plenist9314333p_lenist
polemist12412363polemist
praxis154012253pr_axis_
preaxial1746973preaxial
prebuilt1247033prebuilt
precast11314853pr_ecast
precis103416703pr_ecis_
precise113518173pr_ecise
predict12315323pr_edict
preeing103817673pree_ing
preelect1249643preelect
preemie11310563preemi_e
preemies12512193preemies
preempt1337723pree_mpt
preempts1444543preempts
preenact12410183preenact
preening113115843preening
preens85020113pree_ns_
preerect1259273preerect
prees75937173pree__s_
preexcite2044683preexcite
preexempt2251903preexempt
preexilic2042533preexilic
preexistent2053633preexistent
preexisting2144223preexisting
preexpose2043703preexpose
premise113818553pr_emise
premiss113513813pr_emiss
premixt183510663pr_emixt
preppiest1236973preppiest
preprint12314183preprint
preriot9316413pr_eriot
presentist12410093presentist
presift12312223pr_esift
prest75736353pr_e__st
preterit10315843preteri_t
preterits11410963preterits
pretest9517633pr_etest
pretext1639663pretex__t
pretexts1735603pretexts_
prettiest1199803prettiest
previse123713793pr_evise
previsit13410073pr_evisit
prexes154915953pr_exes_
prexies163415003pr_exies
priest84125423prie__st
prosaist10611583prosaist
protist9320223pr_otist
realist73225383_realist
reediest92815423_reediest
reedit7617223_reedi_t
reedits8511743_reedits
reefiest112811483_reefiest
reekiest122711313_reekiest
reemit8717223_reemi_t
reemits9611303_reemits
reenlist8410363_reenlist
reest54938093_ree__st
relist64628413_r_elist
resist64524533_r_esist
retwist1039483_retwist
revuist1038473_revuist
sexist133013483__sexist

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.423422437.4
2DLD Change Limit146162856.65621959.4
3Display Results85850.0461847.8
 (SQL Overall)178691857.12525079.4
 
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.