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

137 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
preprint1231418(None) 
preprints1347471preprints
reprint9318981_reprint
preparing14311642preparing
preplant12712912preplant
prepping12309762prepping
preprice1488872preprice
preprinted1546542preprinted
preriot9316412pre_riot
repaint9318362_repaint
reprints1039902_reprints
bepaint11312183_bepaint
blueprint1344263blueprint
creping122913653crep_ing
depaint10314593_depaint
drypoint1444793drypoint
erepsin937383erepsin_
erepsins1037443erepsins
eyepoint1345793eyepoint
imprint11312563_imprint
misprint12912973misprint
nonprint10411413nonprint
offprint1643963offprint
overprint14412253overprint
papering132213313papering
peeping123615213peep_ing
peering103520353p_eering
penpoint1249453penpoint
pepino10310333p_ep_ino
pepping113511623p_epping
pepsin10310853p_epsin_
pepsine11310603p_epsine
pepsins11310433p_epsins
peregrin1146993peregrin_
peregrine1247043peregrine
peregrins1246963peregrins
perpent112318813perp_ent
pieplant1268733pieplant
pinpoint1248993pinpoint
piperine122011833piperine
prearming14139223prearming
prebind123810643pre_bind
prebuilt1247033prebuilt
precent113520263pre_cent
precinct1459423pre_cinct
precuring1439423precuring
predict12315323pre_dict
predraft1447593predraft
predried12309573predried
predries112714383predries
predrill1145933predrill
predrying1645343predrying
preedit10512463preedi_t
preeing103817673pre_eing
preening113115843preening
preerect1259273preerect
preexist1747963preexist
prefiring1559073prefiring
prefrank1764233prefrank
pregnant1149883pregnant
prehiring1548383prehiring
premixt183510663pre_mixt
prepaid12310133prepai_d
prepaving1787233prepaving
prepaying1747973prepaying
prepill1147583prep_ill
preplan1149953preplan_
preplans1249613preplans
prepotent1349573prepotent
preppie1058093preppi_e
preppier1156643preppier
preppies1149693preppies
preppiest1236983preppiest
preppily1444593preppily
prepreg12165963prepr_eg
prepregs13144763prepregs
prepress12137983prepress
prepriced1676643prepriced
preprices1569263preprices
prepricing1746733prepricing
preprinting1647413preprinting
prerinse1038633pre_rinse
prescient13411323prescient
prescind1338393prescind
prescript1547033prescript
present94022733pre_sent
preshrink1844773preshrink
presift12312223pre_sift
presplit1247753prespli_t
pressing112516443pressing
preterit10315843preteri_t
pretrain10310923pretrain_
pretrains11410143pretrains
pretreat10311923pretreat
pretrial10511983pretrial
pretrim11310783pretri_m
pretrims1238983pretrims
prevent124016553pre_vent
prevuing1457253prevuing
prewiring1547893prewiring
preying133114553pre_ying
print74837463___print
propine113020213prop_ine
propping122811673propping
propria1149933propri_a
propriety1645433propriety
proprium1447373proprium
prurient1048233pr_urient
pterin81014153pte_rin_
pterins9812993pte_rins
rearing83128783_rearing
refront10313263_refront
regrant8317323_regrant
regrind938983_regrind
remint85329983_re_mint
reorient8613473_reorient
repaints1038483_repaints
repent84728873_rep_ent
repin75324703_rep_in_
repine85627813_rep_ine
repins84924313_rep_ins
replant93318533_replant
repping123314983_repping
reprice113212833_reprice
reprinted1289043_reprinted
reprinter1197353_reprinter
reprise92715043_reprise
reptant92817073_reptant
rerent63832453_re_rent
respring111614063_respring
retint65633443_re_tint
soleprint1147093soleprint
sprint84526793__sprint
surprint1049533surprint
trephine1338933trephine
uprearing1238373uprearing
workprint18103383workprint

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 Limit1461621377.11020557.2
3Display Results1371370.0462978.3
 (SQL Overall)1786911377.57623586.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.