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

199 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
pristine1031350(None) 
pristane10310341pristane
piscine11610972p_iscine
prestige11310732prestige
priesting1239482priesting
primine113214822pri_mine
printing113216082printing
prising103321452pris_ing
prissing113011452prissing
pristanes11410432pristanes
pristinely1544792pristinely
prostie91617742prosti_e
agisting1038243agisting
arcsine94512393arcs_ine
arising83619973aris_ing
aristae7312533arist_ae
aristate8312133aristate
armistice1345033armistice
arsine64021043ar_s_ine
bhistie1236773bhisti_e
brimstone1354623brimstone
brisking15329473brisking
brisling112410843brisling
bristle91910103brist_le
bristling1246663bristling
christie1347783christi_e
creatine103417413creatine
cresting114017043cresting
crimine112413473cri_mine
crisping13319663crisping
cristae9310613crist_ae
cristate10310603cristate
crostini1038293crostini
crostino1038883crostino
crusting113612793crusting
cuisine9310423cuis_ine
cystine1239333_cystine
destine83719953_destine
drifting13338733drifting
dripstone1244153dripstone
drystone1245123drystone
eristic9814093eristi_c
eristics10610193eristics
existing1639073existing
fisting113818123_fisting
foisting122910503foisting
frisking16268363frisking
fritting123510703fritting
frosting12311183frosting
frostline1245883frostline
gratine84719193gr_atine
grifting13299263grifting
griskin1236013griskin_
griskins1335953griskins
gristle8169223grist_le
gritting10309983gritting
heisting123411043heisting
histing113720373_histing
histone10312843_histone
hoisting123610903hoisting
intine61021983__intine
irising83614423iris_ing
isatine7311763__isatine
joisting16328503joisting
listing84020593_listing
mistime11312613_mistime
misting103623383_misting
mistune9310653_mistune
painting113614423painting
palatine10316063palatine
pastie85525523p_asti_e
pastime114611973p_astime
pastina93914593p_astina
pasting103826553p_asting
patine85328123p__atine
peising103416763peis_ing
pepsine11310603peps_ine
perishing1539533perishing
peristome1346593peristome
peristyle1444303peristyle
persisting1346653persisting
philistine1553673philistine
pirating11314513pirating
piscina1177043p_iscina
piscinae1285213p_iscinae
pishing134314373p_ishing
pismire1135353p_ismire
pissing103914803p_issing
piste75824603p_ist__e
pistil83915073p_isti_l
pistils93314303p_istils
pistole92414313p_istole
piston83515923p_iston_
pistons93016373p_istons
pitting103618873p_itting
pliskie1394543pliski_e
pointing112813683pointing
poising103617103pois_ing
pontine92419053p_ontine
positing11312303positing
positive1349993positive
postie84123963p_osti_e
postin83521033p_ostin_
posting105622243p_osting
postins93721203p_ostins
potstone1039423potstone
poutine93316823p_outine
practice1438733practice
practise12310143practise
praising113214563prais_ing
praline93019743pr_aline
prating103424453pr_ating
predestine1349323predestine
prentice121012353prentice
prescind1338393prescind
preside10715613pres_ide
preslice1258623preslice
pressing112516443pressing
prestiges12310593prestiges
prestore104217353prestore
prestrike1547493prestrike
pricing123417343pri_cing
pricking173212603pricking
priding113317543pri_ding
prigging13299093prigging
prilling113413413prilling
primines123013703pri_mines
priming123417373pri_ming
primitive1646393primitive
primming15268173primming
primping15338893primping
primsie1137543primsi_e
principe1445683principe
prinking153212453prinking
printings12268103printings
prise74632613pris___e
prisere9310943pris_ere
prison8514023pris_on_
prisoned1138813pris_oned
prisoner1048573pris_oner
prisoning1237643prisoning
prisons9313223pris_ons
prissier10157873prissier
prissies101712003prissies
prissily1346693prissily
prissiness1266133prissiness
prithee1239933pri_thee
privatise14167763privatise
privative17188293privative
privatize23167043privatize
prizing193514683pri_zing
procaine12312273procaine
proline92321593pr_oline
promine112819443pr_omine
propine113020213pr_opine
prosing103319383pros_ing
prossie91812953prossi_e
prostate10314533prostate
prosties101421193prosties
prostyle13187273prostyle
proustite1147113proustite
puisne856353puis__ne
puristic1239383puristi_c
pyridine1447743pyri_dine
ratine65131823_r_atine
reshine102816943_reshine
resting85031183_resting
restive10315933_restive
retine66237333_r_etine
rifting113515003_rifting
rioting82716393_rioting
riptide1036883_riptide
rising74025883_ris_ing
risking123914243_risking
routine72615903_routine
rusine63916593_rus_ine
rusting83821263_rusting
sestine73017923_sestine
sprinting12310033sprinting
triazine1738503triazine
tricotine1148253tricotine
triptane1047563triptane
tristate8311033tristate
triste63818643trist__e
tristich1348423tristich
tritone73613883tri_tone
trusting93411653trusting
trysting12267053trysting
twisting12427813twisting
uprising1138953upris_ing
uridine81311213uri_dine
ursine64114123ur_s_ine
waisting123615213waisting
waistline1244173waistline
whisting15329543whisting
wisting113519743_wisting
wresting123811833wresting
wristier1136863wristier
writing113713893wri_ting

Search took 9 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 Limit1461621998.17017890.1
3Display Results1991990.0802487.5
 (SQL Overall)1786911998.67320603.1
 
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.