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

221 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
preview153647(None) 
previews1634511previews
review1238691_review
brevier1237762brevier
premie103617992premie_
premier113515632premier
premies113823062premies
prereview1742992prereview
previewed1843422previewed
previewer1743022previewer
previse123713792previse
prevised143611072prevised
previses133814282previses
prevue1179162prevue_
prevued1337142prevued
prevues1239262prevues
prexies163415002prexies
privier122910452privier
privies122414262privies
purview1534232purview
rereview1443912rereview
reviews1335532_reviews
bevies114017303_bevies
breve105317053brev_e_
breves115516423brev_es
brevet115717333brev_et
breviers1335933breviers
brevity1534793brevity
chevied16357483chevied
chevies153511443chevies
crepier1139753crepier
crevice1436153crevice
creviced1634453creviced
crevices1536713crevices
gravies11314093gravies
levied104111433_levied
levier94013873_levier
levies93919863_levies
nervier10298843nervier
overview1736333overview
pareve114613013parev_e_
peavies122213403peavies
peerie83617893peerie_
peeries93623023peeries
peeve104915253peev_e_
peeved124112893peev_ed
peeves113814873peev_es
peeving135112243peeving
peevish1535783peevish
perdie94718513perdie_
perkier133813123perkier
perries93226603perries
pieties9419223pieties
poesies93217403poesies
preaged11612333preaged
preaver121011613preaver
prebid113512843prebi_d
prebids12399883prebids
prebill1138803prebill
prebind123810643prebind
precieux1943033precieux
precipe133012123precipe
precipes143212213precipes
precis103416703preci_s
precise113518173precise
precised133213413precised
preciser123411663preciser
precises123218333precises
precited133013813precited
predial103815413predial
predict12315323predict
predive13511083predive
predried12309573predried
predries112714383predries
pree67044733pre__e_
preed85128123pre__ed
preeing103817673preeing
preemie11310563preemie_
preemies12512193preemies
preen75925053pre__en
preened103214993preened
preener93114833preener
prees75937173pre__es
prefer113813203pre_fer
prefile123413183prefile
prefiled143310573prefiled
prefiles133113443prefiles
prefire124012813prefire
prefired144310753prefired
prefires134313283prefires
prefix18356853prefi_x
prefixed21357703prefixed
prefixes20389233prefixes
prelaw1139103pre_law
prelife1279943prelife
prelim10311423preli_m
prelims1139823prelims
prelives13310383prelives
premed114617763pre_med
premeet11615153premeet
premen105017803pre_men
premiere12249233premiere
premiers122911653premiers
premise113818553premise
premised133013193premised
premises123018273premises
premiss113513813premiss
premium13310363premium
premix173710333premi_x
premixed20338013premixed
premixes193110083premixes
premixt183510663premixt
prepill1147583prepill
prepped11329903prepped
preppie1058093preppie_
preppier1156643preppier
preppies1149693preppies
prepreg12165963prepreg
prequel1836343prequel
preriot9316413preriot
prese75228383pre_se_
preset84430983pre_set
preshow15237413preshow
preside10715613preside
presided12410553presided
presider11410423presider
presides11414913presides
presift12312223presift
pressed103317313pressed
presser93717623presser
presses93523153presses
prester93519623prester
preteen939873preteen
prettied1159253prettied
prettier1069043prettier
pretties10615133pretties
pretzel1835143pretzel
prevail1238243prevail
prevailed1536043prevailed
prevailer1445153prevailer
prevails1337663prevails
prevent124016553prevent
preverb14317063preverb
previewers1842563previewers
previewing1943673previewing
previous1337823previous
previsit13410073previsit
previsor13116303previsor
prevuing1457253prevuing
prewire124311143prewire
prewired14358473prewired
prewires133811013prewires
prexes154915953pre_xes
preyed125313203pre_yed
preyer114413733pre_yer
preying133114553preying
prezes173614693pre_zes
pricier113313113pricier
pried84426863pr__ied
priedieu1153983priedieu
prier75027763pr__ier
pries74339533pr__ies
privet113821343priv_et
priviest132310313priviest
privily15207623privily
privity15268323privity
prosier93817493prosier
prove104823193prov_e_
proved125016033prov_ed
proven114314773prov_en
prover113819723prov_er
proves114322253prov_es
provide1339853provide
provided1536843provided
provider1436703provider
provides1439883provides
proving134214073proving
proviso1237313proviso
proxies163014933proxies
purviews1642533purviews
rechew14310213_rechew
redrew10309513_redrew
reflew12389453_reflew
regrew10388563_regrew
reive85522943_reive_
reived104518133_reived
reiver95318293_reiver
reives95723043_reives
relied74926233_relied
relief94419683_relief
relier65826183_relier
relies65036423_relies
renew83917513_re_new
rereviews1542353rereviews
resew84519503_re_sew
retie55735303_retie_
retied75924983_retied
reties65436193_reties
revel84423163_rev_el
revet84938843_rev_et
reviewal1443523_reviewal
reviewed1534823_reviewed
reviewer1434133_reviewer
revile94921613_revile
reviled114417923_reviled
reviler104314973_reviler
reviles104421353_reviles
revise94019743_revise
revised113815483_revised
reviser104114663_reviser
revises104220533_revises
revive124914823_revive
revived144211653_revived
reviver134411373_reviver
revives134715543_revives
revue81114453_revue_
revues9813903_revues
revved13469723_revved
teleview1443463teleview
trevet94818913trev_et
view105917673___view

Search took 7 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 Filter1786911340270.420425454.8
2DLD Change Limit1340272216.17321711.8
3Display Results2212210.0762907.9
 (SQL Overall)1786912216.66926794.3
 
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.