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

216 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
apprise1131019(None) 
appraise1247701appraise
apprised1337711apprised
appriser1246781appriser
apprises12310961apprises
apprize2038181apprize
aperies9423202aperies
aphorise1339982aphorise
appease1137912appease
applies11311222applies
appose10411992app_ose
appraised1445592appraised
appraisee1345972appraisee
appraiser1344952appraiser
appraises1347422appraises
apprisers1345052apprisers
apprized2236542apprized
apprizer2145462apprizer
apprizes2137792apprizes
approve14116602approve
appulse1134672appulse
apyrase1236362apyrase
arise56436432a__rise
emprise11310722emprise
prise74632612__prise
reprise92715042reprise
uprise82313692_uprise
vaporise13209632vaporise
abris75722603a_bris_
abscise1145953abscise
acarine9316003acarine
acerose9310893acerose
advise10139223a_dvise
aerie54634603a_eri_e
aeries64737783a_eries
agarose838673agarose
agonise83112693agonise
ahorse9311513ahor_se
airwise1036713airwise
alpine84417373alp_ine
ambries111614553ambries
amorist9317643amorist
amortise10428513amortise
anise55129703a__nise
anywise1345203anywise
aorist64827873a_orist
apatite9312963apatite
apelike13310533apelike
apers76629133aper_s_
aphis105917133a_phis_
aphorised1546363aphorised
aphorises14310003aphorises
aphorism1548643aphorism
aphorist13412513aphorist
aphorize2249043aphorize
apiaries10312733apiaries
apiarist10412063apiarist
apish105116633a_p_ish
aplite8316393a_plite
apocrine1246933apocrine
aporia8315863apori_a
aporias9315153aporias
appals104812943appals_
appeased1335793appeased
appeaser1245953appeaser
appeases1238663appeases
appels104312793appels_
appetiser1344443appetiser
appetite1258493appetite
applause1243663applause
apple94517673app__le
apples104315763apples_
applied1247483applied
applier1137903applier
applique2142583applique
appoint11612483appoint
apposed1247853app_osed
apposer1147483app_oser
apposes11511473app_oses
apposite12410013apposite
appraisal1343633appraisal
appraisees1443153appraisees
appraisers1443503appraisers
appraisive1753203appraisive
appressed1445943appressed
apprising1447963apprising
apprizers2243833apprizers
approved16115073approved
approver15105303approver
approves15126833approves
apps86319693app__s_
appulses1234893appulses
apres75426403a_pres_
apse67725383a_p__se
apsis75718293a_psis_
apyrases1337243apyrases
ariose64818723a__riose
arisen65316793a__risen
arises65233803a__rises
arose55832083a__rose
arris56824683a_rris_
arrises71617583a_rrises
arrive91311793a_rrive
arse46539273a__r_se
ascribe1147743ascribe
asperse94210663asperse
aspire8612123asp_ire
aspires9612043aspires
aspis74618143asp_is_
aspises9611643asp_ises
aspish114810333asp_ish
astride8311973astride
atomise93013823atomise
attrite7311833attrite
auris55331533a_uris_
aurist65027253a_urist
avarice1238033avarice
averse95811183aver_se
azotise1637073azotise
azurite1638003azurite
baptise1139553baptise
caprice1349683caprice
caprine11314233caprine
capris10415083capris_
cerise84822043_cerise
comprise14310813comprise
cuprite1159683cuprite
deprive1338303deprive
emprises12311003emprises
emprize2038843emprize
frise85322453__frise
imprese1138143imprese
japeries17311463japeries
leprose938543leprose
naperies10313903naperies
nappie104112263napp_i_e
nappies114613403napp_ies
operose939433operose
oppose1039193opp_ose
oppress1135993oppress
paise75028333__paise
papism122211513pap_ism
papist102618753pap_ist
papoose1147513papoose
pappies103214833pappies
pappoose1143803pappoose
pappose1047413pappose
paprica1337003paprica
paprika1544003paprika
papyrine1546053papyrine
paries84742513_paries
paris75145943_paris_
parises94827183_parises
parish115022353_parish
parries93925843parries
parse75236993_par_se
parvise124211693parvise
pavise114714803_pavise
peise75825773__peise
peris75537073_peris_
perish114619063_perish
perse75429523_per_se
peruse84016843_peruse
phrase11109903_phrase
poise75127893__poise
porism104518063_porism
porose84818743_porose
praise84419413_praise
prase76128753__prase
prese75228383__prese
price93725413__price
pride84724733__pride
pries74339533__pries
prime96525603__prime
prised94322203__prised
prises84133173__prises
prism94820263__prism
priss74623893__priss
prize164718943__prize
prose75835123__prose
purine85321893_purine
puris75332023_puris_
purism104715063_purism
purist85525053_purist
purse76028893_pur_se
pyrite11913313_pyrite
reappraise1453323reappraise
reprice113212833reprice
reprised112012203reprised
reprises102615463reprises
rerise64325633_rerise
rise45945233___rise
sapphire1543803sapphire
sapphism1743813sapphism
sapphist1545773sapphist
satirise8310683satirise
sparse84516343spar_se
speise84614253_speise
sprite84421773_sprite
sunrise7310813sunrise
surprise1037673surprise
updries10209083updries
uppile10178503upp_ile
uppish1336633upp_ish
upraise9158603upraise
uprisen9227353_uprisen
upriser9218763_upriser
uprises92012733_uprises
uprose82311483_uprose
valorise112110313valorise
vaporised15216953vaporised
vaporises14209453vaporises
vaporish16246733vaporish
vaporize22239173vaporize
warpwise1642853warpwise
yperite1249893yperite

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272168.43615887.5
3Display Results2162160.0633428.6
 (SQL Overall)1786912168.90520066.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.