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

141 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
apprizes213779(None) 
apprises12310961apprises
apprize2038181apprize_
apprized2236541apprized
apprizer2145461apprizer
apprizers2243831apprizers
aperies9423202aperi_es
aphorizes2348012aphorizes
applies11311212appli_es
appraises1347422appraises
apprise11310192apprise_
apprised1337712apprised
appriser1246782appriser
apprisers1345052apprisers
approves15126832approves
emprizes2138132emprizes
prizes173819812__prizes
vaporizes23228522vaporizes
acarines10314343acarines
aeries64737783a_eri_es
agatizes1838863agatizes
agenizes18269743agenizes
agnizes17328843a_gnizes
agonizes182610583agonizes
alpines94016193alp_ines
ambries111614553ambri_es
amortizes2087283amortizes
anodizes1837963anodizes
apatites10311293apatites
aphides134711203a_phides
aphorises14310003aphorises
aphorize2249043aphorize_
aphorized2446443aphorized
aphorizer2345403aphorizer
aphorizers2443583aphorizers
apiaries10312723apiari_es
apices104916263a_p_ices
aplites9314933a_plites
apomixes1934853apomixes
aporias9315153apori_as
appeases1238663appeases
appetites1347513appetites
appetizer2244433appetizer
appetizers2343023appetizers
apples104315763app__les
applied1247483appli_ed
applier1137903appli_er
appliers1235573appliers
appliques2242553appliques
appoints1286403appoints
apposes11511473app_oses
appraise1247703appraise_
appraised1445593appraised
appraisee1345973appraisee
appraisees1443153appraisees
appraiser1344953appraiser
appraisers1443503appraisers
apprizing2347193apprizing
approve14116603approve_
approved16115073approved
approver15105303approver
approvers16104913approvers
appulses1234893appulses
apres75426403a_pr__es
apsides103911303a_psides
apyrases1337243apyrases
arabizes1969103arabizes
arborizes2088823arborizes
arises65233803a__rises
arrises71617583a_rrises
arrives101311513a_rrives
ascribes1246193ascribes
aspires9612043asp_ires
aspises9611643asp_ises
assizes1638453a_ssizes
atomizes192711433atomizes
attrites8311563attrites
avarices1337183avarices
azotizes1636853azotizes
azurites1737283azurites
baptizes2136843baptizes
calorizes202312293calorizes
capizes20410373cap_izes
caponizes2238703caponizes
caprices1439893caprices
capsizes2147203capsizes
comprizes2468943comprizes
cuprites1259023cuprites
deprives1438393deprives
disprizes2148113disprizes
emprises12311003emprises
emprize2038843emprize_
frizes184015463__frizes
japanizes2745163japanizes
japeries17311463japeri_es
laterizes18513013laterizes
maderizes2148953maderizes
misprizes2247223misprizes
naperies10313903naperi_es
nappies114613393napp_i_es
odorizes1837213odorizes
pappies103214823pappi_es
papricas1447053papricas
paprikas1643853paprikas
paries84742513_pari_es
parises94827183_parises
parries93925843parri_es
pauperizes2344773pauperizes
peptizes21269853peptizes
phizes20389133__phizes
prezes173614693__prezes
prices104524543__prices
prides94324183__prides
pries74339533__pri_es
primes104225263__primes
prises84133173__prises
prize164718943__prize_
prized184415393__prized
prizer174714883__prizer
prizers183911843__prizers
purines94420763_purines
pyrites12812203_pyrites
reprices122913353reprices
reprises102615463reprises
sapphires1644033sapphires
satirizes1849393satirizes
sprites94220333_sprites
spritzes1946943_spritzes
surprizes2045593surprizes
unprized2038513unprized
updries10209083updri_es
uppiles11208263upp_iles
uprises92012733_uprises
upsizes18297163_upsizes
valorizes21249073valorizes
vaporises14209453vaporises
vaporize22239173vaporize_
vaporized24227353vaporized
vaporizer23236143vaporizer
vaporizers24244113vaporizers
yperites13310153yperites

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.436409841.7
2DLD Change Limit1461621417.89018525.0
3Display Results1411410.0502820.0
 (SQL Overall)1786911418.37621333.7
 
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.