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

217 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
apprises1231096(None) 
appraises1347421appraises
apprise11310191apprise_
apprised1337711apprised
appriser1246781appriser
apprisers1345051apprisers
apprizes2137791apprizes
aperies9423202aperi_es
aphorises14310002aphorises
appeases1238662appeases
applies11311212appli_es
apposes11511472app_oses
appraise1247702appraise_
appraised1445592appraised
appraisee1345972appraisee
appraisees1443152appraisees
appraiser1344952appraiser
appraisers1443502appraisers
apprize2038182apprize_
apprized2236542apprized
apprizer2145462apprizer
apprizers2243832apprizers
approves15126832approves
appulses1234892appulses
apyrases1337242apyrases
arises65233802a__rises
arrises71617582a_rrises
aspises9611642asp_ises
emprises12311002emprises
parises94827182_parises
prises84133172__prises
reprises102615462reprises
uprises92012732_uprises
vaporises14209452vaporises
abatises10311013abatises
abscises1246233abscises
acariases1146613acariases
acarines10314343acarines
adonises92611433adonises
advises11138973a_dvises
aegises8311373a_egises
aeries64737783a_eri_es
agaroses938823agaroses
agonises92613163agonises
alpines94016193alp_ines
ambries111614553ambri_es
amorists10411333amorists
amortises1178823amortises
anises64826693a__nises
anureses837973anureses
aorists74215833a_orists
apatites10311283apatites
aphereses1466423aphereses
apheses12610703a_pheses
aphides134711203a_phides
aphorise1339983aphorise_
aphorised1546363aphorised
aphorisms1647193aphorisms
aphorists1448263aphorists
aphorizes2348013aphorizes
apiaries10312723apiari_es
apiarists1147883apiarists
apices104916263a_p_ices
aplites9314933a_plites
apoapses1244713apoapses
apodoses1136653apodoses
apomixes1934853apomixes
apophases1647973apophases
apophyses1946113apophyses
apoptoses1346443apoptoses
aporias9315153apori_as
appease1137913appease_
appeased1335793appeased
appeaser1245953appeaser
appeasers1345263appeasers
appetiser1344443appetiser
appetisers1442933appetisers
appetites1347513appetites
applauses1344033applauses
apples104315763app__les
applied1247483appli_ed
applier1137903appli_er
appliers1235573appliers
appliques2242553appliques
appoints1286403appoints
appose10411993app_ose_
apposed1247853app_osed
apposer1147483app_oser
apposers1236283app_osers
appraisal1343633appraisal
appraisals1452673appraisals
appressed1445943appressed
apprising1447963apprising
approve14116603approve_
approved16115073approved
approver15105303approver
approvers16104913approvers
appulse1134673appulse_
apres75426403a_pr__es
apses76823913a_p__ses
apsides103911303a_psides
apyrase1236363apyrase_
arise56436433a__rise_
arisen65316793a__risen
arrases71214543a_rrases
arrives101311513a_rrives
arses55733873a__r_ses
ascribes1246193ascribes
asperses104111673asperses
aspires9612043asp_ires
atomises103514403atomises
attrites8311563attrites
aurists74615783a_urists
avarices1337183avarices
axises134413993a__xises
azotises1737603azotises
azurites1737283azurites
baptises1238923baptises
brises84927613__brises
caprices1439893caprices
cerises94722253_cerises
comprises15510943comprises
crises84529433__crises
cuprites1259023cuprites
cypreses1535143cypreses
cypruses1534313cypruses
deprives1438393deprives
derrises93012783derrises
emprise11310723emprise_
emprizes2138133emprizes
frises94124273__frises
gaposises1245523gaposises
hubrises1337103hubrises
hybrises1645423hybrises
impreses1238093impreses
irises64221173__irises
japeries17311463japeri_es
krises105016083__krises
lapises93513463lap_ises
lorises73918593_lorises
merises93421423_merises
morrises10711073morrises
naperies10313903naperi_es
nappies114613393napp_i_es
opposes1149243opp_oses
oppress1135993oppres_s
oppresses1346873oppresses
orrises71312233_orrises
papisms13238543pap_isms
papists112110453pap_ists
papooses1248053papooses
pappies103214823pappi_es
pappooses1243983pappooses
papricas1447053papricas
paprikas1643853paprikas
papyruses1643223papyruses
pareses94718883_pareses
paries84742513_pari_es
parishes13314753_parishes
parries93925843parri_es
parses85534703_par_ses
parvises133911913parvises
pastises103616053pastises
pavises125315493_pavises
peises84125043__peises
penises9318193_penises
perishes13313753_perishes
perses85428063_per_ses
peruses94018163_peruses
phrases12711463_phrases
poises84226543__poises
porisms113713453_porisms
praises94121103_praises
prases84429023__prases
prices104524543__prices
prides94324183__prides
pries74339533__pri_es
primes104225263__primes
prise74632613__prise_
prised94322203__prised
prisms104915503__prisms
priss74623893__pris_s
prisses94816713__prisses
prizes173819813__prizes
proses84733473__proses
purines94420763_purines
purisms114110833_purisms
purists94014073_purists
purses84826373_pur_ses
pyrites12812203_pyrites
reappraises1553093reappraises
reprices122913353reprices
reprise92715043reprise_
reprised112012203reprised
rerises73525883_rerises
rises55244043___rises
sapphires1644033sapphires
sapphisms1843523sapphisms
sapphists1644103sapphists
satirises9410193satirises
speises93813933_speises
sprites94220333_sprites
sunrises8310693sunrises
surprises1137433surprises
tapises92914013tap_ises
updries10209083updri_es
uppiles11208263upp_iles
upraises10188473upraises
uprise82313693_uprise_
uprisen9227353_uprisen
upriser9218763_upriser
uprisers10206773_uprisers
valorises122210183valorises
vaporise13209633vaporise_
vaporised15216953vaporised
vaporizes23228523vaporizes
yperites13310153yperites

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.1531167915.0
2DLD Change Limit1461622177.14320462.3
3Display Results2172170.0762855.3
 (SQL Overall)1786912177.37224239.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.